Viewing 15 posts - 32,746 through 32,760 (of 49,552 total)
Grant Fritchey (5/25/2010)
How on goddess' green earth do you get to be an MC flipping A and not have a full understanding of natural & artificial keys?
MCA, in this case,...
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
May 25, 2010 at 10:12 am
Grant Fritchey (5/25/2010)
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
May 25, 2010 at 9:11 am
karthikeyan-444867 (5/25/2010)
I am sure we shouldn't create Clustered index/primary key on an IDENTITY column.
There's a big, massive, huge difference between not using an int identity for a primary key 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
May 25, 2010 at 9:11 am
Hang on, is this a SQL 2000 server? I know you said 2008, but this is something that could happen on SQL 2000, but not more recent versions.
SELECT @@version
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
May 25, 2010 at 9:06 am
pobeda (5/24/2010)
05/24/2010 04:00:04,spid15s,Unknown,SQL Server has...
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
May 25, 2010 at 4:43 am
Paul White NZ (5/25/2010)
Whatever figure you decide on, remember to send 80% of it to the people on here that have helped you over the last year 😀
Only the last...
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
May 25, 2010 at 4:36 am
A CTE can only be referenced in the query that immediately follows it. It doesn't have batch or procedure scoping. You can repeat the CTE definition before the second insert,...
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
May 25, 2010 at 4:35 am
Paul White NZ (5/25/2010)
It sucks a bit as a solution for reasons already given in this thread (not SARGable) but that doesn't stop people using it.
Also doesn't stop people 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
May 25, 2010 at 4:30 am
Without seeing the code, it's very, very hard to give any useful advice.
Watch out for the lack of statistics on table variables. you're probably getting bad execution plans as a...
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
May 25, 2010 at 2:58 am
Oksana March (5/25/2010)
I know memorizing the answers is not a...
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
May 25, 2010 at 2:16 am
What errors are there in the SQL error log?
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
May 25, 2010 at 1:44 am
Mornings and evenings are getting nippy up here too. Looks like it's going to cool down further over the weekend.
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
May 25, 2010 at 1:44 am
Duplicate post. No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic927206-146-1.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
May 25, 2010 at 1:43 am
spatemp (5/24/2010)
1) it either recompiles stored proc on every use2) or the sql statement inside the "if" are not cached etc....
Neither is true.
What you can get is a form of...
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
May 25, 2010 at 1:39 am
You cannot take a backup of a database on a SQL 2008 instance and restore it on SQL 2000. Once a database is attached to a SQL 2008 instance, 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
May 25, 2010 at 1:38 am
Viewing 15 posts - 32,746 through 32,760 (of 49,552 total)