Viewing 15 posts - 43,876 through 43,890 (of 49,552 total)
ronefrati (10/11/2008)
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
October 11, 2008 at 12:50 pm
PaulB (10/11/2008)
Jeff, by definition you do not delete on staging tables;
By what definition?
A delete on a staging table is like saying "I don't care about this row coming from...
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
October 11, 2008 at 12:33 pm
Jeff Moden (10/11/2008)
... and, here's the tests... these work on both 2k and 2k5. According to Gail's fine blog, some of these tests will not work on 2k8 (which...
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
October 11, 2008 at 12:25 pm
Well, as the error says, CURRENT OF is only allowed for updates and deletes. You use FETCH to get values into variables. Fetch isn't always next. You can get the...
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
October 11, 2008 at 8:55 am
Or, since you're using 2005 you can simply use
SELECT name from sys.databases where state = 'OFFLINE'
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
October 11, 2008 at 8:42 am
No way to know directly. If you need that info, you'll have to add a piece of code to each proc to log when it last ran. Can't do that...
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
October 11, 2008 at 8:40 am
A trigger always runs within the context of the transaction started by the statement that fired it. If you issue a rollback statement within a trigger you will roll back...
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
October 11, 2008 at 8:40 am
Look in Books Online for the index architecture. You'll notice that the index is in the form of a tree. The 4 rows refer to different levels of the index....
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
October 11, 2008 at 8:35 am
More than slightly better...
http://sqlinthewild.co.za/index.php/2008/09/04/comparing-date-truncations/
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
October 11, 2008 at 8:24 am
Duplicate post.
Please direct replies to:
http://www.sqlservercentral.com/Forums/Topic584339-5-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
October 11, 2008 at 8:22 am
PaulB (10/11/2008)
you know for a fact uniqueness is enforced on the source dataset
I wish all the source data that I had to work with was as clean 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
October 11, 2008 at 8:21 am
The MCDBA is for SQL 2000 and is close to retirement, if not already retired.
Look at the MCITP (Database admin) for SQL 2005.
http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
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
October 11, 2008 at 8:19 am
ronefrati (10/11/2008)
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
October 11, 2008 at 8:09 am
You cannot attach a database on a network drive. Copy the file to the server's drives and you'll be able to attach 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
October 11, 2008 at 7:58 am
ronefrati (10/11/2008)
Unfortunately It is obvious that you are hardheaded without dynamic thinking.
That was uncalled for. Please be respectful and polite to the other forum members, especially the ones 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
October 11, 2008 at 7:55 am
Viewing 15 posts - 43,876 through 43,890 (of 49,552 total)