Renaming Server with SQL
I recently had to rename my laptop on which I have two SQL server instances. I have a default instance...
2013-03-14
1,703 reads
Blog Posts
SQL Server : Part 4 :Explaining the Non Clustered Index Structure
A table can have only one clustered index as the data rows are stored in the order of the clustered...
2013-03-14
30,653 reads
SQL Server under source control with Team Foundation Services and Red-Gate Source Control
During the last few years I’ve been involved in database source control management and release plans tasks. These are important...
2013-03-14
798 reads
The STUFF function
While I was at the 2011 Pass Summit I was given the following piece of code to create a comma...
2013-03-14
911 reads
Why you need Business Intelligence
First lets define what Business Intelligence (BI) is. My favorite definitions:
Forrester Research: “Business Intelligence is a set of methodologies, processes,...
2013-03-14
2,067 reads
Adding a Linked Server with ‘Oracle Provider for OLE DB’ as the provider – Proceed with caution !
Adding a linked server is an easy task which can be done at any point of time. I was under...
2013-03-13
2,945 reads
Atlanta MDF Presents Five Pre-Cons to choose from in Atlanta Friday, May 17
SQL Saturday is returning to Atlanta on May 18th at Georgia State University – Alpharetta, 3775 Brookside Pkwy, Alpharetta, GA 30022
The...
2013-03-13
203 reads
Atlanta MDF Presents Five Pre-Cons to choose from in Atlanta Friday, May 17
SQL Saturday is returning to Atlanta on May 18th at Georgia State University – Alpharetta, 3775 Brookside Pkwy, Alpharetta, GA 30022 The day before the event Atlanta MDF is...
2013-03-13
25 reads
Cleaning orphaned SIDs after a SQL Server VM template deployment
A few weeks ago (or longer, I’m behind on email again) Nate Palm (LinkedIn) messaged me after the most recent...
2013-03-13 (first published: 2013-03-11)
1,683 reads
Find missing indexes using SQL Servers index related DMVs
Today, we experienced performance issues with few databases that are hosted on one of our most critical production SQL Server....
2013-03-13
1,929 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