2015-10-01 (first published: 2015-09-13)
1,964 reads
2015-10-01 (first published: 2015-09-13)
1,964 reads
2015-09-30 (first published: 2015-09-17)
1,830 reads
Yet another Script To get Sql server version Info. Run From Central Management server to get all your environment servers
2015-09-29 (first published: 2015-09-10)
1,783 reads
2015-09-28 (first published: 2015-09-10)
1,198 reads
A script to show how to solve arithmetic expressions step-by-step, for my 9-year old daughter.
2015-09-25 (first published: 2015-09-09)
1,213 reads
A script to document the output columns of all the SPs in a given database, with a HTML formatted document
2015-09-24 (first published: 2015-09-08)
2,005 reads
This script will show you all open transactions from any query windows.
2015-09-23 (first published: 2013-01-14)
3,906 reads
2015-09-22 (first published: 2012-10-01)
4,821 reads
Returns a summary of CPU usage by SQL Server over the last 4 hours (default).
Using the sample values collected in the dm_os_ring_buffers dmv, this query will show CPU usage by the SQL Server process for the last for hours even if you have no other benchmarking activities in place on your server yet.
2015-09-18 (first published: 2014-05-14)
5,622 reads
This script generates a graphical timeline of all SQL jobs with a variable zoom level
2015-09-17 (first published: 2013-01-14)
6,753 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers