SQL Server Disable Indexes and Rebuild Indexes dynamically
To generate the ALTER INDEX..DISABLE and the ALTER INDEX..REBUILD statements for all nonclustered indexes for a single table use the...
2012-01-05
1,177 reads
PASS Summit Evals – Plan Cache Querying
This past year, I spoke at the PASS Summit for the second time. The first time was a couple years...
2012-01-04
777 reads
Speaking at Knoxville SQL Server User Group
I am excited to announce that I will be giving a virtual presentation to the Knoxville SQL Server User Group. ...
2012-01-04
997 reads
Have You Planned Which SQL Server Events You Will be Attending in 2012?
2012 is already upon us and I have been busy working on my travel schedule for this year. It is...
2012-01-04
678 reads
January Question: What feature(s) of SQL Server would you like to learn more about?
Although SQL Server 2012 coming out this year, I think some of us are still trying to catch up with...
2012-01-04
689 reads
SharePoint 2010 Your Backup Is From A Different Version Of Microsoft SharePoint Foundation
Restoring a SharePoint site collection can be a pretty easy task. If your interested in how to do that check...
2012-01-04
1,579 reads
Difference between ETL and ELT
ETL is the most common method used when transferring data from a source system to a data warehouse. But there...
2012-01-04
7,594 reads
Daemon
At the recommendation of Jorge Segarra (Blog | Twitter), I got the book Daemon. Well, I actually got that about a year ago as a gift – but it...
2012-01-04
10 reads
Daemon
At the recommendation of Jorge Segarra (Blog | Twitter), I got the book Daemon. Well, I actually got that about a...
2012-01-04
903 reads
Presenting at OPASS on January 10, 2012
I’m stepping out of blogging-break mode for a few minutes to share that I’ll be presenting Building Your Professional Development...
2012-01-04
689 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Alamat Kantor BCA KCU SEMARANG Tlp:08218154374
WA CS 628218154374 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah...
Alamat Kantor BCA KCU CIREBON Tlp:08218154374
WA CS 628218154374 Jl. Yos Sudarso No.27, Lemahwungkuk, Kec. Lemahwungkuk, Kota Cirebon, Jawa Barat...
Alamat Kantor BCA KCU CIKARANG Tlp:08218154374
WA CS 628218154374 Madison Square, Business Park Lippo Cikarang, Jl. MH. Thamrin No.163, Cibatu,...
Question of the Day
Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers