Seven Reasons You Should Attend SQLBits 7
SQLBits is Europe’s Largest SQL Server Event
That’s right, just take a moment to let that point hit home. If you...
2010-07-22
883 reads
SQLBits is Europe’s Largest SQL Server Event
That’s right, just take a moment to let that point hit home. If you...
2010-07-22
883 reads
"Defend Your Data"
If you’re a SQL Server Database Administrator and you don’t know what CHECKDB is then you need to...
2010-07-14
541 reads
One of the great things about working with SQL Server is the opportunity to be involved in our fantastic SQL...
2010-07-13
592 reads
As a DBA you will encounter processes, code and design decisions within your environment that require change for the better....
2010-07-01
629 reads
Like most DBA’s I’m sure you often find yourself delivering information to the business concerning the performance of your SQL...
2010-06-30
1,528 reads
Whilst perusing the forums over at SQL Server Central today I stumbled across an interesting question regarding how to identify...
2010-06-25
579 reads
I know that you have seen it yourself too. That forum or blog post that contains “advice” that is daft,...
2010-05-02
585 reads
Part 2 of the SQL Server Essentials Series looks at why you should be using the Full Recovery Model to protect your data assets.
2009-09-21
9,157 reads
Tweaking SQL Server memory settings to provide support for managed code.
2009-07-06
12,441 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