Create Database Script
I always try to enforce standards across all the SQL Servers I manage, it makes tons of administrative tasks much...
2012-09-21
1,368 reads
I always try to enforce standards across all the SQL Servers I manage, it makes tons of administrative tasks much...
2012-09-21
1,368 reads
This is the third year that Andy Warren and myself are hosting a networking dinner in Seattle, just before the...
2012-09-20
1,160 reads
Lately I’ve been toying with the idea of using PowerShell to parse the Windows event logs and possibly adding that...
2012-09-20
7,570 reads
I recently stumbled across a little gem of a utility called tablediff. I have been working a lot with replication...
2012-09-20
6,773 reads
Do you like training? Do you like FREE training? Then make sure you check out the 24 Hours of PASS...
2012-09-20
1,296 reads
SQL Server 2012 has been in RTM since the 1st April 2012. Many of my clients have been evaluating the...
2012-09-20
1,117 reads
I saw a post about a user defined table type in SQL Server and I was sure it was a...
2012-09-19
148,493 reads
In Master Data Services (MDS), when using the Master Data Manager Web User Interface (“UI”), you will notice the “Leaf member...
2012-09-19
824 reads
Ayyyy, matey being that today is the International Speak Like a Pirate Day I thought it was appropriate to post some future...
2012-09-19
382 reads
24 Hours of Pass is tomorrow. If you haven’t registered yet, now is a good time.
I expect to:
Have little to no...
2012-09-19
536 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...
Wa:082374977784 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...
Wa:082374977784 Jl. Jenderal Sudirman Lt Dasar, RT.1/RW.3, Gelora, Kecamatan Tanah Abang, Kota Jakarta Pusat,...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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