Viewing 15 posts - 39,406 through 39,420 (of 49,552 total)
Go for it.
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
April 28, 2009 at 4:17 pm
You can also use the OBJECTPROPERTY function to see if a table has an identity. Check OBJECTPROPERTY in Books Online
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
April 28, 2009 at 3:09 pm
It just means that the query that the client app submitted did not complete in the allowed time (default 30 sec). It may be that the query needs optimising or...
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
April 28, 2009 at 2:53 pm
I don't know if you can buy SQL 2000 any longer. It's been out of support for about a year now. Is upgrading to SQL 2008 an option?
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
April 28, 2009 at 2:20 pm
Lynn Pettis (4/28/2009)
I have another game tonight, but I should be able to finish up by Friday.
No real urgency.
Thanks
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
April 28, 2009 at 2:03 pm
WayneS (4/28/2009)
Side note: wouldn't it be better to have those 3 different select statements to be in separate procs, with this proc controlling which one gets run?
Quite possibly.
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
April 28, 2009 at 1:59 pm
Try this.
SELECT TOP 3 Status, MaxID AS ID
FROM
(SELECT Status, MAX(ID) AS MaxID FROM SomeTable GROUP BY Status) sub
ORDER BY Status
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
April 28, 2009 at 1:56 pm
A trace that you already had running....
SQL 2000 doesn't store info on what queries it has run in the past and by who.
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
April 28, 2009 at 1:07 pm
Grant Fritchey (4/28/2009)
Hmmm... Now I am confused.
You and me both. I started writing a blog post on this, explaining that there could be serial and parallel plans in cache. It...
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
April 28, 2009 at 12:59 pm
SQL Trace.
See here for setting up and running a trace:
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
April 28, 2009 at 12:57 pm
tony (4/28/2009)
I have a data table that has multiple columns that have similar data, e.g. skills of a worker.
If changing the table is an option, queries like this will be...
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
April 28, 2009 at 12:13 pm
Lynn Pettis (4/28/2009)
The desert is looking good again...
I might join you this time. For some reason some of the posts over the last few days have been getting to me,...
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
April 28, 2009 at 12:11 pm
Do you want the largest ID for each status?
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
April 28, 2009 at 12:09 pm
MSDE (Desktop engine) is a free restricted version of SQL 2000. It has a number of limitations built into it, one of which is a 5 connection limit. As soon...
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
April 28, 2009 at 12:09 pm
Grant Fritchey (4/28/2009)
You can get two plans into the cache through parallelism. I've done it and seen it.
Mind sharing the secret? Nothing I've tried gets me both a serial and...
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
April 28, 2009 at 12:00 pm
Viewing 15 posts - 39,406 through 39,420 (of 49,552 total)