2015-10-19 (first published: 2013-08-30)
4,420 reads
2015-10-19 (first published: 2013-08-30)
4,420 reads
2015-10-16 (first published: 2013-05-30)
5,763 reads
This script will help you to get the culprit along with IP address and User name which helps us to determine the Blocking root cause.
2015-10-14 (first published: 2013-12-08)
4,480 reads
List all tables in a SQL Server database with the details of them.
2015-10-13 (first published: 2013-02-20)
4,613 reads
To get the IP addresses of Multiple hostnames from below stored procedure.
2015-10-12 (first published: 2013-04-17)
5,838 reads
2015-10-09 (first published: 2014-03-21)
5,046 reads
2015-10-08 (first published: 2015-07-02)
1,127 reads
2015-10-07 (first published: 2015-09-18)
1,656 reads
Sometime due to the heavy load in Exchange servers we received configuration alerts notifications and report delay and that time it is require to move to some other exchange servers to full fill the requirement during the critical periods.
2015-10-06 (first published: 2014-12-19)
1,139 reads
Creates a record of all or part of a Windows PowerShell session in a text file.
2015-10-02 (first published: 2015-09-17)
1,172 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