SQL Server 2008 Diagnostic Information Queries (Nov 2012)
Here is the November 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-11-27
1,151 reads
Blog Posts
Time Pass With Transaction Log - Part 5 INSERT
In this article We are going to INSERT a record in a simple table and try reading Transaction log record.
Note:...
2012-11-27
4,518 reads
Unused Indexes
A sound indexing strategy is paramount to performance in an OLTP system. Not having the correct indexes in place can...
2012-11-27
2,547 reads
What’s the deal with Excel & SSIS?
When it comes to importing data from an Excel sheet with SSIS, Excel has quite a reputation. And not a...
2012-11-27
1,619 reads
Can’t access Operations or Applications tabs from Central Admin WSS 3.0 SP 2
Hey Friends,
Sometime when we try to access central administration and certain tabs like operation and Application management we face issues....
2012-11-26
495 reads
Choose specific folders to sync with SkyDrive
Every time you run the SkyDrive Client on your device, a laptop in my case, all your files from the cloud are downloaded to...
2012-11-26
964 reads
Cyber Monday: Performance Indexing Book is $15
Ever thought you could learn a little bit more about indexing? Now here’s the perfect opportunity. Today only you can...
2012-11-26
817 reads
Every ebook from Apress for $15
Query Performance Tuning. Grant Fritchey. $15. If this doesn’t excite you, nothing will. Apress is offering every e-book for just $15...
2012-11-26
988 reads
Free One Week Passes to PluralSight
As you may know, SQLskills has been creating a lot of great new courses about SQL Server for Pluralsight. Nearly...
2012-11-26
1,189 reads
Last Weeks Top 10 “Reading” Links #8
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-11-26
637 reads
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
Unable to restrict permission
I have 13 restricted views in my EDW DB. 6 of them are created...
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Would You Retire Rather Than ...
Comments posted to this topic are about the item Would You Retire Rather Than...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers