Sometimes It IS The Network
Over the years when a performance problem comes up there is always some speculation that it’s a network issue and...
2013-07-31
1,190 reads
I'm Presenting Today for 24 Hours of PASS!!
Hello Dear Reader! This is just a very quick blog to let you know that the 24 Hour's of PASS...
2013-07-31
1,368 reads
Using DTEXECUI to generate a DTEXEC command line statement the easy way
SSIS is one of those tools that I love and hate at the same time. It’s a great ETL tool...
2013-08-05 (first published: 2013-07-31)
2,756 reads
PASS Virtual Chapter Events : August 2013
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters...
2013-07-31
1,351 reads
PASS SQL Saturday Events : August 2013
PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...
2013-07-31
1,328 reads
Amazon Partners With Cloud vLab To Teach Developers How To Use AWS
Reblogged from TechCrunch: Nobody has ever accused Amazon Web Services of hiding its complexities. It seems even Amazon acknowledges that...
2013-07-31
1,388 reads
SQL Server – How to Download and Install the ‘right’ AdventureWorks Sample Database
One of the first things I did when I began my journey with SQL Server was installing a sample database....
2013-07-31
1,610 reads
At the Top of the Rickety Stairway…
by Steve Bolton
…………As expected, I’ve run into quite a few obstacles while trying to deploy and debug my first plug-in...
2013-07-31
1,088 reads
Partitioning Deck, Demos, and Recording Live!
Hello Dear Reader! This week finds me up in Jacksonville at Pragmatic Works HQ. I'm a little behind in getting...
2013-07-30
1,735 reads
24 Hours Of PASS: 2013 Summit Preview Starts In Less Than 24 Hours!
If you like free SQL Server training you're in luck – starting at 12:00 PM GMT/8:00 AM EDT, July 31 (that's...
2013-07-30
1,354 reads
Blogs
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
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...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Life hack that has worked well for me
I wrote about this several years ago but will contribute again a life hack...
Trying to make this faster using not exists
Hi I have this query that is slow during the 'not in' part of...
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