Answer the Question Asked
“Bill, are you running SQL R2 on your desktop?”
This seems like a simple enough question, yet I usually cannot get...
2012-01-13
868 reads
“Bill, are you running SQL R2 on your desktop?”
This seems like a simple enough question, yet I usually cannot get...
2012-01-13
868 reads
We’ve been awfully busy these last few weeks, what with holidays and work and whatnot. But that hasn’t stopped us...
2012-01-12
701 reads
I just ran across this in a piece of code (that I didn’t write):
… WHERE Thing >GETDATE()- 30
Aaaand it works....
2011-12-19
1,244 reads
I was inspired by fellow blogger and all around good guy Nic Cain (Twitter, blog) to write about the PASS BoD...
2011-12-15
676 reads
In 1986, my big brother Jim accidentally encouraged me on my road to geekdom by purchasing an Apple][e, and later...
2011-12-14
752 reads
I had a brief email discussion recently, which could be effectively be boiled down to:
Them: “Are foreign key constraints more...
2011-12-08
858 reads
Resumes are like opinions, which are like something else: everybody’s got one. And if you don’t have one, then certain...
2011-12-06
3,167 reads
While you wait for my awesome upcoming blog on data exception notification with SSRS, let’s pursue a whim of mine.
I...
2011-11-30
1,680 reads
I put out the call to stop SOPA, and one Twitter friend wrote back:
Good luck! We have it in Denmark....
2011-11-16
555 reads
This will be an unusually political Un-SQL Friday – and it’s two days early, to boot – but I’m making an exception...
2011-11-15
1,065 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