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
Logging into Azure and Office365 with Different Accounts
I have been doing some work on the Modern Apps Live! content that required me to use both an Office365...
2013-03-14
802 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
Index Tuning
This week I've been carrying out some performance tuning of some of the more intensive procedures in one of our environments. Using...
2013-03-21 (first published: 2013-03-14)
3,649 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
PowerShell Usage in DBA Work — Case Study 3/7
As a DBA, sometimes we may need to demonstrate to some stakeholders when a sql server instance was last rebooted,...
2013-03-14
1,189 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
The Work Life Balance for Men
A great piece by LZ Granderson, and one that really make me stop and think a bit. Work and life...
2013-03-13
861 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
Retrieving the next or previous element node value in an Xml blob using XQuery
It’s been a little while since I wrote a blog post on my favourite subject but this is from a...
2013-03-20 (first published: 2013-03-13)
5,336 reads
Blogs
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
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