Inserting Binary Data
There are a number of articles on dealing with the insertion of binary data into SQL Server using BULK INSERT,...
2013-02-17
20,912 reads
Using Foreign Keys to Determine Table Insertion Order
Here's a script to determine, based on your database's foreign key relationships, what the insertion order would be for, say,...
2013-02-17
1,550 reads
A year of SQL Lunchs
Time does fly, and happy birthday SQL Lunch UK.
It has been a year since the first SQLLunch UK, and over...
2013-02-17
714 reads
A Month of PowerShell – Day 17 (Databases: Views)
Welcome to Day 17 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-17
694 reads
Fun with dates
Every year me and a group of friends attend the Royal International Air Tattoo (RIAT) at RAF Fairford, for us it...
2013-02-17
803 reads
A Month of PowerShell – Day 16 (Databases: Triggers)
Welcome to Day 16 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-16
976 reads
I’m dropping the book project
Update:
This book project got its second life. I am now collaborating with another author to bring this book to completion....
2013-02-16
948 reads
Reblog: February 8 to February 14
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-02-15
897 reads
23 Pieces of News and Fluffery (Feb 9-15)
I have a news segment on DBAs@Midnight (our live weekly webshow, tune in tonight at 11pm Central time), but there’s...
2013-02-15
749 reads
A Month of PowerShell – Day 15 (Databases: Adding Foreign Keys)
Welcome to Day 15 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-15
743 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...
Alamat Telp BCA KCP Jatiwangi Hub/Wa. 0817-819-444
Jl. Jend. A. Yani No.224, Jatiwangi, Kec. Jatiwangi, Kabupaten Majalengka, Jawa Barat 45454
Alamat BCA KCP Rengasdengklok Hub/Wa. 0817-819-444
Jl. Raya R.Dengklok No.27, RT.049/RW.011, R.Dengklok Sel., Kec. R.Dengklok, Karawang, Jawa Barat 41352
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