Indexes Out the Window
I ran into a peculiarly puzzling situation with a query I have been tuning of late. The query runs some...
2010-01-26
1,290 reads
Blogs
Finding Invalid SQL Logins
As many of you know the system stored procedure sp_validatelogins is used for finding invalid logins. Although sp_validatelogins is useful there's...
2010-01-19
2,220 reads
Implement a stack in SQL Server using stored procedures
In this article I will show you how to implement a stack. In programming, stacks are a great way to...
2010-01-18
5,995 reads
House of Commons Justice Committee Related to The European Union's Data Protection-Retention Directives
Just this past week on Tuesday afternoon, U.K. Information Commissioner Christopher Graham spoke in the Wilson Room for the House...
2010-01-15
1,548 reads
Error rsAccessDenied : The permissions granted to user 'Toma-PC\Toma' are insufficient for performing this operation.
In my problem of the day, I found this one out on the Microsoft Reporting Services Forum. I bumped my head...
2010-01-14
1,392 reads
That DARN TOMCAT
Here is a challenge that had me stumped for several days. Besides for working with Reporting Services on a day...
2010-01-13
1,708 reads
Goals for 2010
Last year I wrote about my goals for 2009. Yesterday I looked over them and evaluated my performance. I think...
2010-01-12
1,809 reads
2010 First Quarter Goals
I have been reading several blog postings about 2010 goals. First, I want to applaud all of you for setting...
2010-01-12
623 reads
10 Goals For 2010
As is the traditional thing to do at the beginning of a new year I'm making goals for what I'd...
2010-01-12
628 reads
2010-01-12
667 reads
Blogs
Azure – HorizonDB
By Vinay Thakur
As Open Source – PostgreSQL and AI is a growing and powerful DB system,...
A New Chapter: Why I Made the Move from Dayforce to ESO
By gbargsley
A New Chapter: Why I Made the Move from Dayforce to ESO Over the...
Lean Six Sigma – Brief
By Vinay Thakur
When you have a project or system, it has to be optimized, tuned, and...
Forums
ALAMAT KANTOR BCA KCU METRO TLP/WA 0817825533
Hub Cs:0817825533 Jl. Jendral Sudirman No.106, Imopuro, Metro, Kota Metro, Lampung 34111
ALAMAT BCA KCU BANDAR LAMPUNG TLP/WA 0817825533
Hub Cs:0817825533 Jl. Yos Sudarso No.100, Bumi Waras, Kec. Bumi Waras, Kota Bandar Lampung,...
ALAMAT KANTOR BCA KCU JAMBI TLP/WA 0817825533
Hub Cs:0817825533 Jl. Dokter Sutomo No.50-50A, Ps. Jambi, Kec. Ps. Jambi, Kota Jambi, Jambi...
Question of the Day
DBCC CHECKDB Limits II
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers