A DMV a Day – Day 22
The DMV for Day 22 is sys.dm_exec_query_memory_grants, which is described by BOL as:
Returns information about the queries that have acquired...
2010-04-22
1,754 reads
Blog Posts
An Introduction to SQL Server 2008 Change Data Capture
This is an excerpt from my free eBook, Brad’s Sure Guide to SQL Server 2008, which can be downloaded here.
As...
2010-04-22
2,123 reads
Consulting and the MBA
The year is 1991. Nirvana’s Smells like teen spirit is the must-have album of the year. And everyone who is...
2010-04-22
551 reads
e-Ink Improvements
I saw this article on the improvements from E-ink that are coming. There are two videos, one of a better...
2010-04-22
714 reads
I’m on TV at the Tweet-up
I was listening to the announcement of SQL Server 2008 R2 yesterday on a call from Microsoft. It was released...
2010-04-22
731 reads
Index Stats Duplication
I came across a recent posting about seeing multiple entries in sys.dm_db_index_usage_stats for the same index. This kind of behavior...
2010-04-22
2,100 reads
OPASS is pleased to announce - SQLSaturday #49 - Orlando October 16th. Get it on your calendar now.
SQLSaturday #49 - Orlando is now live on the SQLSaturday web site. It will be held on October 16th at Seminole...
2010-04-22
405 reads
PASS Summit Content Survey Results
The results of a survey conducted by the PASS organization have been posted (thanks to the Board for all their...
2010-04-22
634 reads
Rebuilding the Home Server
My Windows Home Server died a month ago, just as I was getting ready to leave the country. I didn’t...
2010-04-22
708 reads
Results of PASS Summit 2010 Content Survey Released
A few weeks back PASS sent out a survey to get input on how to shape the 2010 Summit agenda,...
2010-04-22
537 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