Still contacting the vendor and asking for an explanation is a better response than answering "I have no idea". It just doesn't look professional, I fear what the user must...

Ignore me here, sorry.

Hello,

I was looking on how normally people would create a job and run SQL tasks, I will have to check the SSIS option. I am still surprised...

How about scheduling this query?

-- Find single-use, ad-hoc queries that are bloating the plan cache
SELECT TOP(20) [text] AS [QueryText], cp.size_in_bytes
FROM sys.dm_exec_cached_plans AS cp WITH (NOLOCK)

Hi,

I don't want to add any petrol to the fire, so I'll try and be brief.

Start with the simplest thing I once did - the...

Hi,

the article basically sums up the known quote "the only constant thing in life are changes".

I've been first a system analyst migrating, programming applications (Cobol,...

Thom A (1/11/2017)

---

To export from SQL Server to Excel, you'll need to use the ACE 32bit drivers (The JET drivers are the older drivers and are no longer supported).

It's...

Thanks, the problem is this is an index file that goes to a 3rd party to load data into our web site, so it must be automated, hence without any...

"the database was always slow - it was always slow" - I keep hearing that metric with regards to one of my applications/databases.

That is why I started reading the...