All,
For my project, I need to get familiar with sqlserver2005 in a few
days.But I do not have any books or links, so please provide any links
or books to learn about sqlserver205.
Thanks in advance,
DevrajHi
SQL Server 2005 is a such a large area that there is probably no single book
that will tell you everything. As you have a short timescale you will have t
o
decide how/what you are going to limit yourself to. If you just want a
product overview then check out the SQL Server website at
http://www.microsoft.com/sql/default.mspx. Books online is also a very good
place to start especially if you are familiar with previous versions of SQL
Server. If you want an overview of how to administer SQL Server 2005 then yo
u
may want to look at Microsoft? SQL Server? 2005 Administrator's Pocket
Consultant
http://www.microsoft.com/mspress/books/6794.asp if you wish to purchase
other books you may want to browse Amazon or Barnes and Nobel and check out
the sample chapters.
John
"hidevraj@.gmail.com" wrote:
> All,
> For my project, I need to get familiar with sqlserver2005 in a few
> days.But I do not have any books or links, so please provide any links
> or books to learn about sqlserver205.
> Thanks in advance,
> Devraj
>|||On 27 Apr 2006 22:50:10 -0700, hidevraj@.gmail.com wrote:
>All,
> For my project, I need to get familiar with sqlserver2005 in a few
>days.But I do not have any books or links, so please provide any links
>or books to learn about sqlserver205.
Hi Devraj
Do you already have experience with SQL Server 2000? If so, then this
message I just sent to someone else will also apply to you.
On Thu, 27 Apr 2006 12:55:34 -0700, Jeremy S. wrote:
>My situation is this: while I have been working extensively with SQL Server
>2000 for 5+ years and am quite comfortable with it, I just took on a projec
t
>that will require SQL Server 2005. The project starts in 3 weeks and I
>haven't really looked at 2005 yet.
>I would appreciate suggestions for reading (links, books, etc) to help me
>get up to speed on 2005.
Hi Jeremy,
I've recently picked up Pro SQL Server 2005 by Thomas Rizzo and a bunch
of others. I've chosen it because it's focus is almost exclusively on
the changes between 2000 and 2005. I didn't want to clutter my bookshelf
with yet another book explaining SELECT and WHERE but I did want to read
about the new features - and this book provided exactly what I wanted. I
must admit that the chapters on XML didn't quite appeal to me, but all
the chhapters before that (on installation, management, T-SQL
enhancements, and .Net integration) were great. I have yet to read the
remaining chapters (on Reporting Services, Analysis Services, security,
Service Broker, automation and monitoring, Integration Services,
Mirroring, and Notification Services).
Another great resource are Microsoft's E-Learning upgrade courses 2936
up to 2944. These all focus on changes between 2000 and 2005. And the
best part is: until November 1, 2006, they are free!
https://www.microsoftelearning.com/...05/default.aspx
Hugo Kornelis, SQL Server MVP
Showing posts with label links. Show all posts
Showing posts with label links. Show all posts
Sunday, March 25, 2012
books needed
All,
For my project, I need to get familiar with sqlserver2005 in a few
days.But I do not have any books or links, so please provide any links
or books to learn about sqlserver205.
Thanks in advance,
DevrajHi
SQL Server 2005 is a such a large area that there is probably no single book
that will tell you everything. As you have a short timescale you will have to
decide how/what you are going to limit yourself to. If you just want a
product overview then check out the SQL Server website at
http://www.microsoft.com/sql/default.mspx. Books online is also a very good
place to start especially if you are familiar with previous versions of SQL
Server. If you want an overview of how to administer SQL Server 2005 then you
may want to look at Microsoft® SQL Server� 2005 Administrator's Pocket
Consultant
http://www.microsoft.com/mspress/books/6794.asp if you wish to purchase
other books you may want to browse Amazon or Barnes and Nobel and check out
the sample chapters.
John
"hidevraj@.gmail.com" wrote:
> All,
> For my project, I need to get familiar with sqlserver2005 in a few
> days.But I do not have any books or links, so please provide any links
> or books to learn about sqlserver205.
> Thanks in advance,
> Devraj
>|||On 27 Apr 2006 22:50:10 -0700, hidevraj@.gmail.com wrote:
>All,
> For my project, I need to get familiar with sqlserver2005 in a few
>days.But I do not have any books or links, so please provide any links
>or books to learn about sqlserver205.
Hi Devraj
Do you already have experience with SQL Server 2000? If so, then this
message I just sent to someone else will also apply to you.
On Thu, 27 Apr 2006 12:55:34 -0700, Jeremy S. wrote:
>My situation is this: while I have been working extensively with SQL Server
>2000 for 5+ years and am quite comfortable with it, I just took on a project
>that will require SQL Server 2005. The project starts in 3 weeks and I
>haven't really looked at 2005 yet.
>I would appreciate suggestions for reading (links, books, etc) to help me
>get up to speed on 2005.
Hi Jeremy,
I've recently picked up Pro SQL Server 2005 by Thomas Rizzo and a bunch
of others. I've chosen it because it's focus is almost exclusively on
the changes between 2000 and 2005. I didn't want to clutter my bookshelf
with yet another book explaining SELECT and WHERE but I did want to read
about the new features - and this book provided exactly what I wanted. I
must admit that the chapters on XML didn't quite appeal to me, but all
the chhapters before that (on installation, management, T-SQL
enhancements, and .Net integration) were great. I have yet to read the
remaining chapters (on Reporting Services, Analysis Services, security,
Service Broker, automation and monitoring, Integration Services,
Mirroring, and Notification Services).
Another great resource are Microsoft's E-Learning upgrade courses 2936
up to 2944. These all focus on changes between 2000 and 2005. And the
best part is: until November 1, 2006, they are free!
https://www.microsoftelearning.com/sqlserver2005/default.aspx
--
Hugo Kornelis, SQL Server MVP
For my project, I need to get familiar with sqlserver2005 in a few
days.But I do not have any books or links, so please provide any links
or books to learn about sqlserver205.
Thanks in advance,
DevrajHi
SQL Server 2005 is a such a large area that there is probably no single book
that will tell you everything. As you have a short timescale you will have to
decide how/what you are going to limit yourself to. If you just want a
product overview then check out the SQL Server website at
http://www.microsoft.com/sql/default.mspx. Books online is also a very good
place to start especially if you are familiar with previous versions of SQL
Server. If you want an overview of how to administer SQL Server 2005 then you
may want to look at Microsoft® SQL Server� 2005 Administrator's Pocket
Consultant
http://www.microsoft.com/mspress/books/6794.asp if you wish to purchase
other books you may want to browse Amazon or Barnes and Nobel and check out
the sample chapters.
John
"hidevraj@.gmail.com" wrote:
> All,
> For my project, I need to get familiar with sqlserver2005 in a few
> days.But I do not have any books or links, so please provide any links
> or books to learn about sqlserver205.
> Thanks in advance,
> Devraj
>|||On 27 Apr 2006 22:50:10 -0700, hidevraj@.gmail.com wrote:
>All,
> For my project, I need to get familiar with sqlserver2005 in a few
>days.But I do not have any books or links, so please provide any links
>or books to learn about sqlserver205.
Hi Devraj
Do you already have experience with SQL Server 2000? If so, then this
message I just sent to someone else will also apply to you.
On Thu, 27 Apr 2006 12:55:34 -0700, Jeremy S. wrote:
>My situation is this: while I have been working extensively with SQL Server
>2000 for 5+ years and am quite comfortable with it, I just took on a project
>that will require SQL Server 2005. The project starts in 3 weeks and I
>haven't really looked at 2005 yet.
>I would appreciate suggestions for reading (links, books, etc) to help me
>get up to speed on 2005.
Hi Jeremy,
I've recently picked up Pro SQL Server 2005 by Thomas Rizzo and a bunch
of others. I've chosen it because it's focus is almost exclusively on
the changes between 2000 and 2005. I didn't want to clutter my bookshelf
with yet another book explaining SELECT and WHERE but I did want to read
about the new features - and this book provided exactly what I wanted. I
must admit that the chapters on XML didn't quite appeal to me, but all
the chhapters before that (on installation, management, T-SQL
enhancements, and .Net integration) were great. I have yet to read the
remaining chapters (on Reporting Services, Analysis Services, security,
Service Broker, automation and monitoring, Integration Services,
Mirroring, and Notification Services).
Another great resource are Microsoft's E-Learning upgrade courses 2936
up to 2944. These all focus on changes between 2000 and 2005. And the
best part is: until November 1, 2006, they are free!
https://www.microsoftelearning.com/sqlserver2005/default.aspx
--
Hugo Kornelis, SQL Server MVP
Wednesday, March 7, 2012
BLOCKING
I need help to understand how to minimise or completely stop blocking.
any help, tips or links will be highly appreciated. I have gone thru
couple of article about blocking but not specified how to stop
blocking. i will appreciate if some one can give me concept about
blocking & how it can be stopped. Agian any help will be highly
appreciatedA good place to start is SQL Server Books Online -> Accessing and Changing
Relational Data -> Transactions
and
SQL Server Books Online -> Accessing and Changing Relational Data -> Locking
http://msdn.microsoft.com/library/d...
ap1.asp
"myrights99@.gmail.com" wrote:
> I need help to understand how to minimise or completely stop blocking.
> any help, tips or links will be highly appreciated. I have gone thru
> couple of article about blocking but not specified how to stop
> blocking. i will appreciate if some one can give me concept about
> blocking & how it can be stopped. Agian any help will be highly
> appreciated
>|||(myrights99@.gmail.com) writes:
> I need help to understand how to minimise or completely stop blocking.
> any help, tips or links will be highly appreciated. I have gone thru
> couple of article about blocking but not specified how to stop
> blocking. i will appreciate if some one can give me concept about
> blocking & how it can be stopped. Agian any help will be highly
> appreciated
A very wide topic, and different blocking scenarios requires different
actions.
But generally, make sure that your queries have suitable indexes. Queries
that requires table scans, can be quite obtrusive. It's also good to keep
transactions as short as possible. Particularly, never have a transaction
open while waiting for user input.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
any help, tips or links will be highly appreciated. I have gone thru
couple of article about blocking but not specified how to stop
blocking. i will appreciate if some one can give me concept about
blocking & how it can be stopped. Agian any help will be highly
appreciatedA good place to start is SQL Server Books Online -> Accessing and Changing
Relational Data -> Transactions
and
SQL Server Books Online -> Accessing and Changing Relational Data -> Locking
http://msdn.microsoft.com/library/d...
ap1.asp
"myrights99@.gmail.com" wrote:
> I need help to understand how to minimise or completely stop blocking.
> any help, tips or links will be highly appreciated. I have gone thru
> couple of article about blocking but not specified how to stop
> blocking. i will appreciate if some one can give me concept about
> blocking & how it can be stopped. Agian any help will be highly
> appreciated
>|||(myrights99@.gmail.com) writes:
> I need help to understand how to minimise or completely stop blocking.
> any help, tips or links will be highly appreciated. I have gone thru
> couple of article about blocking but not specified how to stop
> blocking. i will appreciate if some one can give me concept about
> blocking & how it can be stopped. Agian any help will be highly
> appreciated
A very wide topic, and different blocking scenarios requires different
actions.
But generally, make sure that your queries have suitable indexes. Queries
that requires table scans, can be quite obtrusive. It's also good to keep
transactions as short as possible. Particularly, never have a transaction
open while waiting for user input.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
Friday, February 10, 2012
Bitmap index in sql server
Hi
I was using bitmap index in Oracle and now moving to SQL Server 2000. Is there any "equivalent" of bitmap index in sql server ? Any help / links ?
Thanks,
SamIf I'm not mistaken a bitmap index also indexes null values. As far as I know, sqlserver does not have special indexes (not) considering specific null values. A regular index will work. Lookup Indexes in Books Online (BOL).
In the analyzer (turn on execution plan):
use monkey
go
set nocount on
create table tab1 (myint integer null, myval integer not null)
go
create index idx_tab1_myint on tab1 (myint)
go
insert into tab1 (myint, myval) values (1,1)
insert into tab1 (myint, myval) values (null,2)
go
select myint from tab1
go
drop table tab1
go|||A bitmap index is an index that can be used on columns with little different values in it (eg sexe: values male, female and unknown/null), for example in Oracle. This type of index is not available in SQL Server.
If I'm not mistaken a bitmap index also indexes null values.
In SQL Server you can also create indexes that allow null values
I was using bitmap index in Oracle and now moving to SQL Server 2000. Is there any "equivalent" of bitmap index in sql server ? Any help / links ?
Thanks,
SamIf I'm not mistaken a bitmap index also indexes null values. As far as I know, sqlserver does not have special indexes (not) considering specific null values. A regular index will work. Lookup Indexes in Books Online (BOL).
In the analyzer (turn on execution plan):
use monkey
go
set nocount on
create table tab1 (myint integer null, myval integer not null)
go
create index idx_tab1_myint on tab1 (myint)
go
insert into tab1 (myint, myval) values (1,1)
insert into tab1 (myint, myval) values (null,2)
go
select myint from tab1
go
drop table tab1
go|||A bitmap index is an index that can be used on columns with little different values in it (eg sexe: values male, female and unknown/null), for example in Oracle. This type of index is not available in SQL Server.
If I'm not mistaken a bitmap index also indexes null values.
In SQL Server you can also create indexes that allow null values
Subscribe to:
Posts (Atom)