SQL in the City
That’s where we were on Friday. 780 Third Avenue, in the middle of Manhattan. The start of our 2012 US...
2012-10-01
1,224 reads
That’s where we were on Friday. 780 Third Avenue, in the middle of Manhattan. The start of our 2012 US...
2012-10-01
1,224 reads
I was able to attend the SQL in the City event in New York this past Friday. I highly recommend...
2012-10-01
728 reads
Come and join me live in New York this coming December where I will be presenting Learning Tree’s2109 SQL Server...
2012-10-01
847 reads
Issue : When running DBCC CHECKDB on SQL server 2000, We are facing t-log growth & blocking.
Cause : DBCC CHECKDB does block in...
2012-10-01
624 reads
The Omaha SSUG’s sister group, the Lincoln SSUG, is hosting a SQL Saturday this coming Saturday, October 6th, at Avery...
2012-10-01
707 reads
I sat down this afternoon after being out of town for week to work on a few things in my...
2012-09-30
1,556 reads
SQL Server 2012 is best known for its bombastic new features: AlwaysOn, Columnstore indexes, Window functions enhancements, Extended Events enhancements,...
2012-09-30
1,126 reads
SQL Server Integration Services (SSIS) execution is sequential by default. SQL Server Integration Services (SSIS) does allow parallel execution. Now question is how we can configure SSIS to run...
2012-09-29
304 reads
Querying Microsoft SQL Server : Basics of Triggers in SQL Server: SQL Triggers: A trigger is a procedural code like stored...
2012-09-29
1,426 reads
Querying Microsoft SQL Server : Basics of Indexes in SQL Server: Indexes in SQL Server: If you see a book, in...
2012-09-29
1,294 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