Sql Server - Monitoring the Performance of All Stored Procedures
Monitoring the Performance of All Stored Procedures
Every Project suffer from this problem, over the time they
have developed many stored procedure...
2016-08-31
599 reads
Monitoring the Performance of All Stored Procedures
Every Project suffer from this problem, over the time they
have developed many stored procedure...
2016-08-31
599 reads
I’ve got a session this fall at the IT/DevConnections conference (Oct 10-13, 2016) called “Who’s Touching My Database?” This is...
2016-08-30
858 reads
Today, I want to focus on how we can monitor wait statistics in an Azure SQL Database. In the past,...
2016-08-30
1,047 reads
Within the world of SQL Server there are a few things one can be certain of - things will change. This is true of the features in SQL Server....
2016-08-30
17 reads
Within the world of SQL Server there are a few things one can be certain of – things will change. This...
2016-08-30
829 reads
Earlier this year, I wrote a long post about log shipping. One of the key points I mentioned was how slow restoring can be for a read only log...
2016-08-30
18 reads
In this module you will learn how to use the Tornado Power BI Custom Visual. The Tornado allows you to...
2016-08-29
1,085 reads
I’ve put up a Twitter poll to find some answers to the question: Why do speakers teach at events? Especially at...
2016-08-29
855 reads
Azure SQL Data Warehouse can sometimes feel like it’s completely different from SQL Server, but under the covers, it is...
2016-08-29
1,094 reads
Hello Dear Reader! I had recently written a blog for the PFE blog, "How Many Tables Can I Have In SQL Azure DB & SQL Server". It was...
2016-08-29
19 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...
Wa:082374977784 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...
Wa:082374977784 Jl. Jenderal Sudirman Lt Dasar, RT.1/RW.3, Gelora, Kecamatan Tanah Abang, Kota Jakarta Pusat,...
Has anyone ever seen this before? I have sysadmin permission on a server. 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 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