How can I force Sql Server to not use the cache or other optimizations so that the same query always takes the same amount of time? When trying to tune...

I wrote a little monitor program that queries the database every 30 seconds checking for blocking sql. Usually the query returns nothing. If it does return some data, the program...

Heh, funny the timestamp on my message is "April 16, 2019 at 2:19 pm". I posted it at 10.19 AM.

Yes, we store both the server time and the "User PC Time" in the AuditTable. When the user is looking at the audits, they can see the local pc time....

Great advice! In C it's called printf and people would joke about me using the "printf debugger". It's especially useful to minimize timing changes when debugging a race condition. "It...

I think it is a HIPPA violation to run on unsupported software if your product is used with protected health information (PHI).

/****** Object: Table [dbo].[AUDITTABLE]  Script Date: 6/6/2018 2:19:13 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[AUDITTABLE](
    [TRANSACTION_TIME] [datetime] NULL,
    [OBJECT_TYPE] [varchar](900) NULL,

Yes, nine of the columns are indexed. I don't think Transaction_date is used.

I like the idea of using a view for lookups.

I'm sorry for your loss.

There is no such thing as "I don't have time". Everyone has the same amount of time. It's all about your priorities on how you use it.

“Time isn’t...

Crap, all I had to do was read the title and I would have got it right.

"they're" not "there". Sign of aging.

The security issue is addressed by new hardware (routers).  Here's an excerpt from a recent USA Today article:
<quote>
Multiple devices that offer home protection from hacks are set to...

I am on my wife's insurance and want a bonus from my employer for not using our insurance here! I am saving them money.