Viewing 15 posts - 37,351 through 37,365 (of 49,552 total)
The exams for the MCDBA certification have been retired. It is not possible to write them any longer.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 30, 2009 at 3:53 am
Amit (7/29/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 30, 2009 at 3:52 am
SARG meaning Search ARGument. It refers to a where clause expression that SQL can use as part of an index seek. There are lots of things that could make an...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2009 at 12:48 pm
Nero (7/29/2009)
could you please elaborate??
What's there to elaborate? SQL runs on Windows Operating system only. It is not possible to install it on any version of *nix.
Elliott's talking about virtualisation,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2009 at 12:00 pm
Are there any .ndf files for that database? How big's the log file (.ldf)?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2009 at 10:54 am
Specify the COLLATE clause, either on the select or on the definition of the table.
Without seeing at least the form of the function in question, I can't really be more...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2009 at 10:51 am
Plus when you shrink you're fragmenting all of your indexes. If you don't rebuild, you're likely to get poor performance. If you do rebuild, the DB's going to grow as...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2009 at 10:46 am
I bought a office chair from a second-hand office supplier about 8 years ago. Other than the seat getting a little hard (I bought a cushion) and my cats using...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2009 at 9:06 am
ps (7/29/2009)
i'm not sure but see if updating statistics of the table helps...
Not update statistics. The counts in sysindexes are not statistics based, they come from the storage engine. You...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2009 at 8:04 am
It comes from neither statistics nor an actual count. A look at the definition of sp_spaceused shows that the row count is calculated from sys.dm_dm_partition_stats.
It's probably the same as sys.partitions,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2009 at 8:02 am
The count in sysindexes can be wrong and should never be considered anything other than an approximate value
Since you're on 2005, try using the row count in sys.partitions. It's also...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2009 at 7:02 am
*sigh* *twitch*
http://www.sqlservercentral.com/Forums/FindPost761393.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2009 at 6:48 am
David Burrows (7/29/2009)
Steve Jones - Editor (7/28/2009)
How about advanced pork chop aiming strategies for maximum developer damage?Oi :angry:
I'm a Developer :crying:
Me too.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2009 at 6:41 am
bhuvnesh.dogra (7/29/2009)
i know this is not right way to ask the problem, so apology for this time
If you know it's not the right way to ask, why are you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2009 at 6:41 am
Amit H (7/29/2009)
Both work equally fast,
No they don't. Count(column) can in some cases be as fast as count(*), it can also be significantly slower.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 29, 2009 at 6:40 am
Viewing 15 posts - 37,351 through 37,365 (of 49,552 total)