Viewing 15 posts - 22,441 through 22,455 (of 49,552 total)
Both crash recovery and log restores work much the same way in bulk-logged as in full. The only difference is that STOPAT can't be used when the specified time is...
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
November 8, 2011 at 5:44 am
SELECT @CountValue = COUNT(ProductID)
FROM Production.Product
WHERE FinishedGoodsFlag=1
However return is not used that way. Return for a procedure is for a status code to tell whether the procedure succeeded or failed. To...
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
November 8, 2011 at 5:15 am
http://msdn.microsoft.com/en-us/library/ms189275.aspx
http://msdn.microsoft.com/en-us/library/ms191244.aspx
http://msdn.microsoft.com/en-us/library/ms186229.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
November 8, 2011 at 5:13 am
MuraliKrishnan1980 (11/8/2011)
No Identity, No index, nothing.. Simpley foreign keys.. As you have all mentioned this should not be a best practice..
Foreign key from this table or referencing this table? If...
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
November 8, 2011 at 3:27 am
Gil_Adi (11/8/2011)
Thanks for every body1. Right now it is a theoretical question on wat is the best practice
The best practice is to write code as simply as possible, without unnecessary...
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
November 8, 2011 at 3:07 am
All too common in badly designed databases.
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
November 8, 2011 at 3:05 am
I still want to know if there is a performance problem or if this is a theoretical question. If the latter, go test, see if the performance is acceptable 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
November 8, 2011 at 3:05 am
Unlikely, the overhead of creating and indexing the temp table will likely outweigh any improvements, unless you're using the deleted and inserted many, many times.
Test it and see.
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
November 8, 2011 at 2:42 am
Gil_Adi (11/8/2011)
So what can be done to boost trigger performance on a large scale update
Depends on what's causing the performance problem
Does Instead of trigger with cte or temporary table is...
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
November 8, 2011 at 2:26 am
SQL Kiwi (11/8/2011)
GilaMonster (11/8/2011)
So much for 'fixed in the next version of SQL'... 🙁
The comments on the Connect item are contradictory, but the most recent one says:
"This is now 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
November 8, 2011 at 2:23 am
SQL Kiwi (11/7/2011)
daveriya (11/7/2011)
i am converting function into sp,can i execute like this exec proc proc_name 'parm1' 'parm2' order by column.
Given that the best solution is to insert into table...
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
November 8, 2011 at 2:21 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1201808-359-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
November 8, 2011 at 2:19 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1201808-359-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
November 8, 2011 at 2:19 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1201808-359-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
November 8, 2011 at 2:18 am
No. The indexes on the base table do not reflect onto the deleted and inserted pseudo tables.
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
November 8, 2011 at 2:18 am
Viewing 15 posts - 22,441 through 22,455 (of 49,552 total)