2011-09-05 (first published: 2007-01-25)
3,609 reads
alzdba
- Interests: family, mantrailing / dogs, riding my motorbike, volleyball
- Twitter: @@alzdba
Reset count for all alerts
To see the frequency of alerts in use, you can reset their fire count.
Restart count from zero for all alerts using the propre stored procedures.
2009-12-22 (first published: 2003-01-14)
421 reads
HowTo prevent BOL getting Online help
Books Online will try to connect to the net and it may get stuck if there is no internet connection.
2008-06-16 (first published: 2008-05-07)
419 reads
2007-12-21 (first published: 2007-10-25)
1,398 reads
help to tighten use of cmdshell or sp_start_job
-- The goal is to avoid the use of sp_start_job in an application. So we have the application use RAISERROR to activate the job.-- 1) because you can only start jobs you own-- 2) we don't want to open the cmdshell to everyone-- 3) we want control regarding jobs that run on our server.-- 4) […]
2007-05-31 (first published: 2004-01-21)
2,033 reads
Detect invalid FK-data after using "WITH NOCHECK"
In situations where FK's have been created using the "WITH NOCHECK" option you can get into troubles because the FK-data is not checked ! (so there may be invalid data in the FK-column !)E.g. ALTER TABLE [dbo].[mytable] WITH NOCHECK add constraint [FK__USED_RESO__Actio__1162CF5F] FOREIGN KEY ( Action_Type ) REFERENCES [dbo].[Action_Types] ( Action_Type ) BOL states "... […]
2007-05-29 (first published: 2006-10-09)
525 reads
VB.Net support from your SQLServer DBA
Once devs are pushed toward using parameters, they get confused as to why their sp is not reused and has many compilations when in use.The reason is most of the time, that the parameters are defined with a wrong datatypemapping in the application or have different datatypes in a # of applications.I use this proc […]
2006-02-16 (first published: 2006-02-06)
275 reads
Intervention system for runaway jobs
Some of my developers had created jobs that executed VB applications that never ended. Aparently they could not figure out when, why and what was going wrong. They could not repro the situation.Now I've created this litle system so the users can assign max elaps times for their jobs. These jobs will then be intercepted […]
2003-03-04
465 reads
Blogs
Hyperconverged storage tuning tip for SQL Server
By kleegeek
We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...
Daily Coping 25 Nov 2022
By Steve Jones
Today’s coping tip is to connect with someone from a different generation. This tip...
Snowflake Classic UI vs Snowsight
By Arun Sirpal
This blog post is not about which User Interface is better, Classic or Snowsight...
Forums
Can someone explain where non - clustered index is stored?
I am learning non-clustered and clustered indexing. When reading this article https://www.sqlshack.com/what-is-the-difference-between-clustered-and-non-clustered-indexes-in-sql-server/#:~:text=Clustered%20indexes%20only%20sort%20tables,involve%20any%20extra%20lookup%20step. came across this...
Null value when checking unused indexes
I'm using this query to check if I have any unused indexes.. One of...
Retrieve Password from CyberArk using powershell
Hi, I am new to Powershell script and i have to create a power...
Ask SSC