OT: Kicked Out of a Motel for Charging at 12 Amps
This is a pretty long story…
My wife and I had an interesting road trip to Salida, CO this past weekend,...
2013-07-16
1,312 reads
Cumulative Updates - SQL Server 2012 SP1 CU5
As part of their Incremental Service Modelling, Microsoft have released SQL Server 2012 Service Pack 1 Cumulative Update #5.To apply this cumulative update package, you must be running SQL...
2013-07-16
28 reads
SQL Server Needs Tempdb
I saw a post recently where someone noted they had moved tempdb like this:
USE master;
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdev,...
2013-07-15
1,212 reads
T-SQL Tuesday #44 Wrap UP
Hello Dear Reader, what a busy week we’ve had last week! I’ve got 3 big Thank You’s that I would...
2013-07-18 (first published: 2013-07-15)
1,966 reads
Guide to SQL Server Table Indexes (Part 1)
One of the most important tasks for every database administrator (DBA) is to ensure that query times are consistent with...
2013-07-15
1,406 reads
Understanding SQL Server Query Optimization Statistics
SQL Server query optimizer uses statistics to create query plans that improve query performance. For most queries, the query optimizer...
2013-07-15
1,532 reads
Microsoft SQL Server security best practices checklist
SQL Server is a repository of sensitive information for organizations, and that is why it is important to ensure that...
2013-07-15
3,434 reads
Understanding SQL Server Database Restore Process
Data is a critical asset for an organization to keep information about their customers, inventory, products, purchasing, and financial stocks....
2013-07-15
708 reads
SQL Server Database Backups and Recovery Models – (Part 3)
Checkout the part-3 of my three part article series on SQL Server Database Backups and Recovery Modelshere, in which I discussed...
2013-07-15
746 reads
SQL Server Database Backups and Recovery Models – (Part 2)
Checkout the part-2 of my three part article series on SQL Server Database Backups and Recovery Modelshere, in which you’ll learn...
2013-07-15
939 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