Reports summaries, in 3 levels of detail, connections, running requests, open transactions + cursors, and blocking. Provides query text + plan for the piggiest running request of each group.
2009-10-26 (first published: 2008-09-18)
5,869 reads
There is an option in Backup Exec (I've never used the option myself, so check out your documentation) to restore to a different location; it's similar to SQL Server's WITH MOVE. -SQLBill
2003-06-30
Replication is enabled for specific databases and should not effect how the others operate. However, depending on push or pull an where the distributor is they can chnge the server loads which does effect overall performance. And DTS is not the same as replication although you can create a custom datamove similar to the concept […]
2003-06-27
Thanks for your input I realized the problem...I had to also include the Dbname.table.columnname in the where clause..
2003-06-26
1 reads
Ok, I went back to BOL and looked at the syntax. The IDENTITY option is only available if you are adding a column. ALTER COLUMN allows you to add or drop ROWGUIDCOL but not IDENTITY. EM does it by creating a new table with the IDENTITY property, copying the data to it, dropping the old […]
2003-06-17
quote: Is the SQL built dynamically? I miss spoke above. In addition to passing the procedure dynamic global temp table names, I am also passing it various parameters for WHERE clauses. I replaced the dynamic global temp tables with static temp tables. did not help.
2003-05-30
1 reads
This month’s T-SQL Tuesday is hosted by a dear friend, long time SQL Server...
By Steve Jones
I almost missed this month, so this is also a good #SQLNewBlogger post. I...
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers