should I use clustering on a VM?
ok, I'm going to keep this high level and simply share my opinion.
I am not prescribing anything.
If you want prescriptive...
2012-11-28
894 reads
One Interview question. Many Answers
Conducting technical interview is an art.
Most likely I would start a discussion with simple questions like "What is your favourite topic in SQL...
2012-11-27
3,537 reads
SQL Server 2008 Diagnostic Information Queries (Nov 2012)
Here is the November 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-11-27
1,163 reads
Querying Performance Counters in SQL Server
In a previous post, there was a comparison between sysperfinfo and sys.dm_os_performance_counters which included the use of a simple query. ...
2012-12-06 (first published: 2012-11-27)
6,880 reads
Billing rates – other side of the fence
The following is a guest post by Tim Morgan from Sullexis in response to a resent blog of mine:
Thanks for letting...
2012-11-27
1,686 reads
Unused Indexes
A sound indexing strategy is paramount to performance in an OLTP system. Not having the correct indexes in place can...
2012-11-27
2,568 reads
What’s the deal with Excel & SSIS?
When it comes to importing data from an Excel sheet with SSIS, Excel has quite a reputation. And not a...
2012-11-27
1,648 reads
Time Pass With Transaction Log - Part 5 INSERT
In this article We are going to INSERT a record in a simple table and try reading Transaction log record.
Note:...
2012-11-27
4,549 reads
Are Your Protecting Your DB Backups?
Folks have cited the recent InformationWeek article on how South Carolina's Department of Revenue was hacked because the SC state government...
2012-11-27
3,186 reads
Help Bring #SQLFamily to Fargo, North Dakota
Did you know that a SQL Saturday in Fargo is in the works? If not them, hey… there’s a SQL...
2012-11-30 (first published: 2012-11-26)
1,186 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas 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 one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers