SQL Server || Change Batch separator
SQL Server utilities interpret GO as a keyword to separate the batch. GO is not a Transact-SQL statement. it is...
2012-09-25
2,090 reads
SQL Server utilities interpret GO as a keyword to separate the batch. GO is not a Transact-SQL statement. it is...
2012-09-25
2,090 reads
(article published on the MVP Award Program Blog) I really enjoy this topic. One of the reasons, I suppose, it’s...
2012-09-27 (first published: 2012-09-25)
2,756 reads
In the last post, we have discussed the script to list the sessions which are waiting for resource or currently...
2012-09-24
1,174 reads
I’m not a fan of trivia style interview questions. Yes, I ask a few because you have to in order...
2012-09-26 (first published: 2012-09-24)
3,358 reads
Microsoft has posted ALL the session videos for TechEd Austrialia 2012 and they are available for free! Get your learning...
2012-09-24
807 reads
Its not often I publish two blog posts in a single day but this Monday I will make an exception....
2012-09-24
978 reads
This coming Saturday (September 29th) we’ll be having our sixth annualSQLSaturday at Seminole State College (our site partner since the...
2012-09-24
661 reads
December this year will be a great month for me. I am scheduled to deliver my new Learning Tree course...
2012-09-24
700 reads
We welcomed daughter #3 and child #5 into this world on Saturday at 9:43 AM. She came a bit earlier...
2012-09-24
1,492 reads
I had the opportunity to present DMV Emergency Room! at SQLSaturday #169 in Denver, Colorado on September 22, 2012.
I...
2012-09-23
1,159 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