Career Growth and How You Can Achieve Explosive Results
Continued investment in your professional development for career growth is hard. It’s also essential to being a successful Data Professional.
You’ve...
2013-03-05
1,534 reads
Continued investment in your professional development for career growth is hard. It’s also essential to being a successful Data Professional.
You’ve...
2013-03-05
1,534 reads
The sys.dm_exec_connections DMV (Dynamic Management View) is represented by Books Online (BOL) as follows : http://msdn.microsoft.com/en-us/library/ms181509.aspx
Returns information about the connections established...
2013-03-05
1,505 reads
Assuming you’ve been on earth lately, you probably heard the terms “Big Data”, “Hadoop”, “NoSQL” and so on.
Companies want to...
2013-03-05
576 reads
What’s wrong with the following code?
SELECT
a.[BusinessEntityID]
, b.[FirstName]
, b.[LastName]
FROM [HumanResources].[Employee] a
INNER JOIN [Person].[Person] b
ON b.[BusinessEntityID] = a.[BusinessEntityID]Nothing – except for my...
2013-03-05
934 reads
What's wrong with the following code?
tsqlLine number Off | Hide | Select allSELECT a.[BusinessEntityID] , b.[FirstName] , b.[LastName]FROM[HumanResources].[Employee] a INNER JOIN [Person].[Person] b ON...
2013-03-05
806 reads
The Big Data revolution will be more important than the PC or the Internet. While there were many...
2013-03-04
35 reads
The Big Data revolution will be more important than the PC or the Internet. While there were many interesting conversations last week at Strata, two new publications captured my...
2013-03-04
58 reads
This spring I’m speaking at the SQL Intersection conference. It’s a new conference, managed by SQLskills founders Kimberly Tripp and...
2013-03-04
1,198 reads
It’s the first Monday of the month, do you know where your servers are?
Hopefully, they are still in your data...
2013-03-04
821 reads
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-03-04
597 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
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 two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers