An Introduction to SQL Server
I will be delivering Learning Tree course 137 SQL Server 2008 a Comprehensive Hands-On Introduction in London this December (18th...
2012-09-17
755 reads
Why I dislike Third Party Database Monitoring Tools
I have to admit I am not a fan of the various 3rd party monitoring tools (after using a few...
2012-09-17
1,917 reads
Logon Triggers: SQL Server
As the name implies, logon triggers fire in response to the logon event that is raised when a user sessions...
2012-09-17
24,390 reads
SQLSaturday #171, Pittsburgh
Date: October 6, 2012
Title: Searching for the Holy Grail of DDL Auditing
Abstract:
Who altered this view and how? When was that...
2012-09-16
696 reads
SQL Server 2012 Diagnostic Information Queries (September 2012)
Here is the September 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-09-16
1,227 reads
Going to the PASS Summit? Join Us at a Networking Dinner
For the third year Steve Jones and I are coordinating a very informal networking dinner on Monday night the week...
2012-09-21 (first published: 2012-09-15)
1,827 reads
Attendant’s checklist to a SQL Saturday event
Weeks Before The Event
Check for conflict in Schedule
Family Activities (Y/N)Business Appointment (Y/N)Other Commitments (Y/N)Plan the Trip
Distance (calculate travel time)Budget $ (Gasoline,...
2012-09-15
720 reads
Certificates of Completion for SQL Seminars
Most managers and employers distinguish between attending a conference and training. We (the royal SQL community we) offer quite a...
2012-09-14
1,128 reads
Update on My Lenovo Laptop
Order status on the web site still shows an estimated ship date of the 4th (of September) for my X1...
2012-09-14
818 reads
Conference in Florida: SQL Server Live
This conference is new to me. In case it’s new to you, I thought I’d take a moment to point...
2012-09-14
988 reads
Blogs
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
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