Is #SQLPASS helping their speakers?
I love the SQL Community because it usually is a great environment to connect, share and learn. With that said,...
2012-10-30
1,632 reads
I love the SQL Community because it usually is a great environment to connect, share and learn. With that said,...
2012-10-30
1,632 reads
Thanks to all who attended my webinar last Thursday on Building Dynamic Cube Reports. You can find my code
Recording:
http://pragmaticworks.com/LearningCenter/FreeTrainingWebinars/WebinarDetails.aspx?ResourceId=470
Code:
http://sdrv.ms/RqxbcF
There are...
2012-10-30
1,648 reads
Still 18 days to go for my session on Transaction Log Internals for Chennai SQL Server User Group (17-Nov).
While seeing...
2012-10-30
2,620 reads
Management Studio is great tool with almost everything you need right at your fingertips. Notice I said "almost". I like...
2012-10-30
2,266 reads
Here are a couple of quick database and table level queries that I have found useful lately.
How many rows in...
2012-10-30
1,633 reads
Last Friday, pretty much on impulse, I decided to go to the Microsoft Store in the Park Meadows Mall in...
2012-10-29
2,405 reads
Eight days to go. So after going to my first conference, I was surprised that I did not know more...
2012-10-29
1,217 reads
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-01 (first published: 2012-10-29)
3,321 reads
1. Set the "blocked process threshold (s)"
sp_configure 'show advanced options', 1 ;
GO
RECONFIGURE ;
GO
sp_configure 'blocked process threshold', 10 ;
GO
RECONFIGURE ;
GO
here we...
2012-10-29
2,658 reads
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out...
2012-10-29
658 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