Catching specific statements using new MI008 "Statement used" rule
Imagine that you want (for some reason) prohibit usage of some statement (or statements), eg - CURSOR
How can you find if...
2015-11-05 (first published: 2015-10-30)
1,877 reads
Imagine that you want (for some reason) prohibit usage of some statement (or statements), eg - CURSOR
How can you find if...
2015-11-05 (first published: 2015-10-30)
1,877 reads
So things are messed up. Bad. I mean, you lost a $2.7 Billion Dollar Secret Blimp or your team accidentally sent...
2015-10-30
1,109 reads
With the proximity to Halloween, it's not hard (knowing me) to figure out why I originally decided to terminate this series on the Eve of Halloween day. Join me...
2015-10-30
10 reads
Halloween is a great time of year. It is unfortunate that it is just one day of the year. That...
2015-10-30
1,030 reads
Blocked processes are often a big problem for DBAs, because they’re difficult to monitor. We receive desperate calls saying “Everything...
2015-11-06 (first published: 2015-10-30)
7,248 reads
PASS 2015 continues in Seattle, and today was my session at 1045am on Using Azure Machine Learning (ML) to Predict Seattle House Prices. The background and info on my session...
2015-10-30
23 reads
PASS 2015 continues in Seattle, and today was my session at 1045am on Using Azure Machine Learning (ML) to Predict Seattle...
2015-10-30
982 reads
As I sit here in an offshoot of the convention center, I started reflecting back to this morning’s keynote for...
2015-10-29
865 reads
Continuation from the previous 70 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In the SQL Server world of data...
2015-10-29
918 reads
I’ve wrapped up my session at my first session at this year’s PASS Summit. My session this Thursday was The Plan...
2015-10-29
819 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
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...
Comments posted to this topic are about the item Data Lost in the Cloud
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