DBCC Memorystatus SQL2012 – A quick observation for node Process/System Counts
This post is not a detailed explanation of DBCC Memorystatus for SQL2012,but a quick observation I made recently for the...
2013-01-11
3,303 reads
This post is not a detailed explanation of DBCC Memorystatus for SQL2012,but a quick observation I made recently for the...
2013-01-11
3,303 reads
Hi all,
registration to attend SQL Bits is now open.
http://www.regonline.com/Register/Checkin.aspx?EventID=1163518
There’s a 600 capacity limit and they anticipate it to fill rather quickly. More details can be found here:
http://sqlbits.com/
Hope to see...
2013-01-11
18 reads
Last year I stepped into the intimidating (and slightly effervescent) waters of the consulting world, and found great success. This...
2013-01-10
784 reads
After upgrading to SQL Server 2012 SP1, I ran into a bug in Master Data Services (MDS) that applies only...
2013-01-10
1,275 reads
Come and join me in London this March for a 3 day course on SQL Server virtualisation and consolidation.The course...
2013-01-10
1,036 reads
Brent Ozar Unlimited released v16 of this sp_blitz script, which is designed to run on a SQL Server instance and...
2013-01-10
1,410 reads
Cross-posted from The Goal Keeping DBA blog:
As a worker in information technology, I’ve always been a big proponent of studying systems...
2013-01-14 (first published: 2013-01-10)
2,175 reads
On February 12th I'll be giving a SQL Server Security Refresher for Midlands PASS at Microstaff IT in Cayce/West Columbia,...
2013-01-10
972 reads
Introduction:
I came across a couple of subtle gotchas around the permissions required to restore a database in SQL Server 2008+...
2013-01-10
6,419 reads
Tried something different for the January 2013 meeting of the Baton Rouge SQL Server User Group (brssug.org), which meets every...
2013-01-10
964 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