Technical Article

RE: Pet Peeves

  • Reply

OK, never mind. Found the book online (took a lot of searching, for some reason). It's called "Dangerous Visions" (1967) and I highly recommend it for SF and/or trip (ta) fans.


Technical Article

RE: Dynamic Index Creation

  • Reply

Hi Mark, The temp table should take care of the number of records. The incentives we're report against generally only run for a couple of months and the data is summarised by consultant anyway. I suspect the largest set would be maybe 300-400 rows. In addition, another parameter defines how many rows we return. Once […]


1 reads

Technical Article

RE: URGENT: Restore fails

  • Reply

There is an option in Backup Exec (I've never used the option myself, so check out your documentation) to restore to a different location; it's similar to SQL Server's WITH MOVE. -SQLBill


Technical Article

RE: something similar to forking a separate process

  • Reply

A real low-tech way would be similar to the method mentioned by stax68. Create a stored procedure to do the work. Set it as a job to run every minute (or whatever frequency seems necessary). The arguments indicating that the process should be run would be entered into a table from your calling program. When […]



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