Choosing the Right Processor for your SQL Server Workload
Last year, we planned to move our data warehouse from a 2 socket server to a 4 socket server that was left in the data centre from an abandoned...
2013-04-26
24 reads
Blog Posts
Does TDE really work on MDF files?
Yes, it does. However, let’s prove it. First let’s create a database, a table, and enter some data:
-- create a...
2013-04-26 (first published: 2013-04-22)
3,454 reads
Gulf Coast SQL Server Users Group Wrapup
Today has been quite the day! This afternoon I presented for the SQL PASS Performance Virtual Chapter and tonight I...
2013-04-26
558 reads
Reblog: April 19 to April 25
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-04-26
1,040 reads
5 SQL Server White Papers Every DBA Should Read
There are countless sources for information on SQL Server available today. There are books, webcasts, conferences, and blogs. With all...
2013-04-25
864 reads
Adding Data to Filestream with T-SQL
I’ve written on how to enable Filestream and how to add a filegroup, but I haven’t touched the Filestream impact...
2013-04-25
1,385 reads
Consultants – Why pay more?
As an independent consultant who has a higher bill rate than average, I would hope it is obvious to clients that the...
2013-04-25
1,425 reads
Database Administration KPIs – 1/2
As a DBA, we may all have this question: How should my work be evaluated objectively? or in another way,...
2013-04-25
537 reads
Database Administration KPIs – 1/2
As a DBA, we may all have this question: How should my work be evaluated objectively? or in another way,...
2013-04-25
3,552 reads
Force installation of 64-bit ACE OLE DB provider
Anyone working with SSIS and Excel probably had the following issue: you are creating an SSIS package using an Excel...
2013-04-25 (first published: 2013-04-23)
13,193 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