Insert multiple values sets into a table in one command
The INSERT command has two distinct ways to load data into a table.
INSERT INTO Table (field1, field2) VALUES ('string1','string2')And
INSERT INTO...
2013-02-28
3,461 reads
A Month of PowerShell – Day 28 (Using Windows PowerShell Remoting)
Welcome to Day 28 of my “A Month of PowerShell” series – the last day. This series will use the series...
2013-02-28
2,054 reads
Dust Off That Resume
Since I started regularly attending SQL Saturday events some five years ago, I’ve sat in on a number of professional...
2013-03-08 (first published: 2013-02-28)
3,159 reads
SQL BLOG: Using Triggers for creating history tables in SQL Server
Case Study:1) We need to track the employee table in terms of new records inserted along with the datetime stamp
2) ...
2013-02-28
9,356 reads
"An item with the same key has already been added."
In SQL Server Reporting Services, when adding a new dataset to a report, you may see an error that looks...
2013-02-28
8,623 reads
Check out IT Central Station
If you get some time, head on out to IT Central Station.com. You can provide some valuable feedback on the...
2013-02-28
1,197 reads
Data Warehouse Architecture Presentation Slides
Thanks to everyone who attended my session “Data Warehouse Architecture” to the PASS DBA virtual chapter. There were over 200 attendees! The recording of...
2013-02-28
1,632 reads
Optimizing Protected Indexes (was Indexing Encrypted Data)
Why bother encrypting?
Riddle me this batman? Why bother to Encrypt?
As a SQL Server DBA I am primarily responsible for making...
2013-02-27
1,834 reads
We’re Live on the PowerScripting Podcast! (Thursday night, 02-28)
Your MidnightDBAs
Unusually, Sean and I will be guests on someone else’s podcast this week! Tune in live to our PowerScripting...
2013-02-27
1,275 reads
Attaching an MDF with no Log (AdventureWorks)
Attaching an MDF file without an LDF file can be a little tricky. I had to go through this recently...
2013-02-27
2,005 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