Query Tuning

External Article

Free eBook: SQL Server Backup and Restore

  • Article

In this free eBook Shawn McGehee offers advice on query tuning, cutting stored procedures, and system process design and implementation for high availability. Discover how to perform backup and restore operations using SQL Server Management Studio (SSMS), basic T-SQL scripts and Redgate's SQL Backup tool.

2020-12-02 (first published: )

80,501 reads

Technical Article

RE: Uploading Data from Text file with different column name

  • Reply

OK, data type mismatch is as it states, there must be a problem with the data or column matching.To convert char date to datetime, use CAST(chardate as datetime). However if the dates are as you posted (28.02.2004) then you will get an error, so you will have to rearrange the data first, egDECLARE @chardate varchar(10) […]


Technical Article

RE: How can I commit more frequently?

  • Reply

I think that using a loop (especially to iterate through a cursor) might be a good idea here, so I'd agree with mom ... BUT ... you don't want to commit every loop iteration if you're retrieving one row per iteration.  That would kill your performance (I could go into painful detail here, but it […]


Technical Article

RE: Proper Shutdown of SQL Servers in a Cluster

  • Reply

it's a .cmd file and I use shutdown.exe from the Resource Kit, though I'll be switching that to psshutdown because it honors the power down as well. It's manually executed by an administrator if needed. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1



What Do I Do to Relax?


I’ve republished an editorial today from another author, called What do you do to...

Daily Coping 9 Dec 2022


Today’s coping tip is to find out something new about someone you care about....

Advent of Code 2022


Foreword Advent of Code is an annual event in which participants solve a series of...

Read the latest Blogs


SSRS - Add end date for all SSRS subscriptions

By pwalter83

Hi, Could you please advice if it is possible to add an end date...


By saintor1

I have been using this for a long time.   It was done initially in...

blank page

By carjara

Hi guys! The topic "Connect to SQL Server with Python to Create Tables, Insert...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Temp Alias

See possible answers