Steady State vs Tempo
It’s helpful at work to understand things at work change from time to time and to consider the impact on you...
2012-04-06
1,012 reads
It’s helpful at work to understand things at work change from time to time and to consider the impact on you...
2012-04-06
1,012 reads
Red Gate Software and SQLServerCentral.com will be one of the sponsors for the upcoming SQL Server 2012 & SharePoint Connections to...
2012-04-05
1,247 reads
Not sure if it is a good news or bad news, SQL Server 2012 license shifts from processor-based to core-based.......here...
2012-04-05
1,960 reads
As I have announced
in my DevWeek and SQLbits sessions, you can find my session materials (slides &
samples) here for download:...
2012-04-05
861 reads
NEST has rolled out a nice software update for their NEST thermostat that gives you a 10 day history of...
2012-04-05
1,084 reads
PowerPivot was a great new tool when it released several years ago. Now the newest version is out along side...
2012-04-05
3,755 reads
I signed up for a few of the SQL Server 2012 Beta certification exams, and have been going through them...
2012-04-05
1,529 reads
As a follow up to an earlier posts - SQL Server - BACKUP LOG WITH NO_LOG
As of SQL Server 2008 , BACKUP...
2012-04-05
5,173 reads
When I had a discussion with couple of my friends about index fragmentation, I realized that they have different understanding...
2012-04-06 (first published: 2012-04-05)
35,407 reads
NEC has submitted the second TPC-E OLTP benchmark result for SQL Server 2012, running on an Express5800/A1080a-E system, which is...
2012-04-05
1,676 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...
Jl. Zainul Arifin No.78, Sukoharjo, Kec. Klojen, Kota Malang, Jawa Timur 65118
Jl. Thamrin No.8, Lawang, Kec. Lawang, Kabupaten Malang, Jawa Timur 65211
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