Performance Tuning Pre-con and More at SQLSaturday 277 RVA
Join me for 2 days of fun and education at SQL Saturday #277 in Richmond, VA on March 21 and...
2014-02-04
970 reads
Join me for 2 days of fun and education at SQL Saturday #277 in Richmond, VA on March 21 and...
2014-02-04
970 reads
I was reading the blog post Time for a Quick Rant by Grant Fritchey (blog|@GFritchey) about people who choose to...
2014-01-20
1,553 reads
I was asked recently by Idera to take a look at the things that could cost a DBA their job....
2014-01-17
1,179 reads
It’s time once again for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday #50 is...
2014-01-14
1,013 reads
I was asked by Idera to take a look at the things that could cost a DBA their job. This...
2014-01-10
1,073 reads
Back in early 2006, I was still working at my first ever DBA job. I had only been a DBA...
2013-12-27
998 reads
A huge round of applause and my thanks to all of the participants and spectators for this month’s edition of...
2013-12-14
1,675 reads
One of the projects I’ve been working on recently was to automate our production SQL Server installs including our standard...
2013-12-13
1,975 reads
I’m not just hosting T-SQL Tuesday, I’m a customer as well. Err, I mean participant. Topic for this month’s T-SQL...
2013-12-10
1,236 reads
You may be thinking, “You’re a DBA. I thought DBAs hated infinite loops.” Well, you’re right, most of the time....
2013-12-09
1,374 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