Performance Impact from Page Splits
Recently I was brought in to help troubleshoot performance issues on a database server. Going through my typical check list...
2013-01-30
1,972 reads
Azure SQL Database Execution Plan Differences
I’ve been exploring execution plans in Azure SQL Databases a lot lately. I’m getting a presentation together for some upcoming...
2013-01-30
1,915 reads
SSIS 6 Million Rows in 30 Seconds using standard laptop
First of all I would like to thank Koen Verbeeck and Joost van Rossum for great suggestions that helped to...
2013-01-30
1,787 reads
SQL Server – Attach Database with MDF file only
Earlier on my blog I posted about how you can attach a database using T-SQL when no log file is...
2013-01-30
2,765 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 5: The Neural Network Algorithm
by Steve Bolton
Anyone who has been following this series of self-tutorials has probably grown accustomed to me adding some...
2013-01-30
2,996 reads
Are You Signed Up for 24 Hours of PASS–Business Analytics?
If you have not signed up for the 24 Hours of PASS-Business Analytics you should be. This is a great...
2013-01-29
1,376 reads
Transactional Replication Toolbox Scripts: Show Articles And Columns For All Publications
During the last few years I've worked extensively with transactional replication and have written a handful of scripts that have...
2013-02-05 (first published: 2013-01-29)
2,778 reads
Determining Filegroup for a Table
Have you ever needed to figure out which filegroup your tables are located within? If you had to do this,...
2013-02-06 (first published: 2013-01-29)
4,796 reads
Cultural Anthropology and Business Intelligence–A Tribute to Dr. Thomas C. Correll
A tribute is an expression of gratitude or praise. Last year I started a series about individuals who have impacted...
2013-01-29
1,639 reads
SSIS 2012: Empty toolbox?
This is an annoying problem I have had a few times: I open a SQL Server Integration Services (SSIS) project...
2013-01-29
5,079 reads
Blogs
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...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
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
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
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