A simple SysProcess query
A quick and simple SysProcess query which will display most of the common parameters of interest.
2011-07-28 (first published: 2011-07-23)
1,370 reads
sysprocesses
2003-11-13
2 reads
RE: Dynamic Index Creation
Hi Tim, quote: I realise this makes it all the more important to use an Order By clause, but I really don't want to run a dynamic select to get my final set. what is dynamic when you add the DESC keyword in your statement SELECT * FROM #tmpIncentive ORDER BY ...(DESC)? Cheers, Frank Edited […]
2003-08-14
2 reads
RE: doh
I ran across something that made me think of your corruption issue. From SQL Server 2000 System Administration - Microsoft Press: (paraphrased to shorten) "Beware of write caching disk contollers - unless the controller is designed for use with a database, you risk corrupting your database. SS2000 relies on the operating system to notify it […]
2003-06-20
Blogs
Daily Coping 7 Dec 2022
By Steve Jones
Today’s coping tip is to stop for a minute when you walk outside and...
Encryption and Data Protection Regulation
One of the reasons you may be considering encryption is due to the relevant...
Types of data consulting engagements and what you can expect from them
There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...
Forums
Any good resource to learn Data Factory ?
I just joined a company and I'm new to Azure. It's a powerful tool...
query, compare and match against values in date and time columns
So, I need to calculate the distance between the UNIT for example LPKC1 to LPKC2,...
SSAS Tabular Excel reports slower after upgrade
Hello, We recently upgraded our SSAS Tabular model from compatibility level SQL Server 2014...
Ask SSC