Last Weeks Top “Reading” Links #67
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-01-20
637 reads
SQL Server 2014 – Buffer Pool Extension
Wanted: more RAM
In an ideal world (well, a DBA’s ideal world, anyway) all database servers would have enough memory to...
2014-01-20
1,393 reads
Time for a Quick Rant
This is an actual quote from what we can only assume is a functional human being:
The database is very big...
2014-01-20
703 reads
Who Do You Rely On?
We tend to think of ourselves as self reliant. Sit and think for a second, how many people do you...
2014-01-24 (first published: 2014-01-20)
1,286 reads
PowerShell – Program List – 32/64 Bit – Local/Remote Machies
This Powershell script list all the installed application on both 32 and 64 bit applications, particularly useful for people managing...
2014-01-20
1,067 reads
Transactions: Who, What and Where
Recently we had a scenario where we had a handful of queries being blocked. Nothing unusual there but when I...
2014-01-23 (first published: 2014-01-20)
3,321 reads
SQL Server – Displaying line numbers in Query Editor – SSMS
You can enable line numbers to be displayed in SSMS Query Editor. This is extremely useful when working on a...
2014-01-20
157 reads
SQL Server – Displaying line numbers in Query Editor – SSMS
You can enable line numbers to be displayed in SSMS Query Editor. This is extremely useful when working on a...
2014-01-20
318 reads
SQL Server – Displaying line numbers in Query Editor – SSMS
You can enable line numbers to be displayed in SSMS Query Editor. This is extremely useful when working on a...
2014-01-20
972 reads
New Blog Series: Parent-Child Architecture in SSIS
I’m kicking off a new series of blog posts discussing the topic of parent-child architectures in SQL Server Integration Services....
2014-01-20
1,361 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