Ten SQL Kindle eBooks for Under $10
Introducing Microsoft SQL Server 201231 Days of SSIS with SQL Server 2008 R2SQL Server Interview Questions and AnswersPerformance Tuning with...
2012-10-07
1,234 reads
Introducing Microsoft SQL Server 201231 Days of SSIS with SQL Server 2008 R2SQL Server Interview Questions and AnswersPerformance Tuning with...
2012-10-07
1,234 reads
Concatenating row values (within groups) into column in SSRS and TSQL
Concatenating row values into column is a never ending topic...
2012-10-07
2,777 reads
Reblogged from Basit's SQL Server Tips:
In my previous post here, I’ve discussed how we can detect fragmentation in SQL Server...
2012-10-07
1,648 reads
2012-10-07
867 reads
When tried to empty one of the tempdb data file using the below T-SQL command: (My goal here is to...
2012-10-07
1,595 reads
Today I presented two sessions at SQL Saturday Lincoln (almost in my backyard!) – Virtualizing Business-Critical SQL Servers and Database Health...
2012-10-07
457 reads
The differences and interactions between class variables and instance variables are well described in the Python 2.x documentation, but they...
2012-10-06
2,381 reads
Issue :
Today, I decided to clear my desktop. I am currently running with around 10 SQL server instances with different...
2012-10-06
1,334 reads
I’ve been unable to connect to a server via one of its aliases for about a week. When I looked...
2012-10-05
2,033 reads
An error message for one of our many SQL Azure databases was brought to my attention today.
Msg 40628, Level 16,...
2012-10-05
2,353 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