Technical Article

RE: Multiple Where Clause

  • Reply

Hi Kenneth,Thanks for the reply. The problem i have is, there will be a multiple contact nos selected from the input parameter. All the contact nos will use in the WHERE clause to select records from TableC and return the result. The contact no selected from table B can be 3 and up to 16 nos.How this can be […]


Technical Article

RE: SQL2K not releasing memory

  • Reply

Thank you for your reply.The server has currently got 4Gb RAM, I have tried setting the memory to fixed starting with 0 min to 1536 max. Reason for 1536 is because it is running standard edition and I read it somewhere that it can only access up to 2Gb of RAM, plus the fact that […]



Hyperconverged storage tuning tip for SQL Server


We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...

Daily Coping 25 Nov 2022


Today’s coping tip is to connect with someone from a different generation. This tip...

Snowflake Classic UI vs Snowsight


This blog post is not about which User Interface is better, Classic or Snowsight...

Read the latest Blogs


Null value when checking unused indexes

By Bruin

I'm using this query to check if I have any unused indexes.. One of...

Retrieve Password from CyberArk using powershell

By Alone

Hi, I am new to Powershell script and i have to create a power...

Multiply time by hourly rate

By pedroccamara

Hello all, I have this table with time for each row. It shows hh:mm....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers