Technical Article

RE: Dynamic Index Creation

  • Reply

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 […]


2 reads

Technical Article

RE: doh

  • Reply

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 […]



Daily Coping 7 Dec 2022


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...

Read the latest Blogs


Any good resource to learn Data Factory ?

By kalpitaru

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

By brian.cook

So, I need to calculate the distance between the UNIT for example LPKC1 to LPKC2,...

SSAS Tabular Excel reports slower after upgrade

By woutgoet

Hello, We recently upgraded our SSAS Tabular model from compatibility level SQL Server 2014...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers