2019-11-01 (first published: 2017-09-11)
5,225 reads
Query Tuning
Free eBook: SQL Server Backup and Restore
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: 2014-03-05)
80,501 reads
RE: Uploading Data from Text file with different column name
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) […]
2005-02-04
RE: How can I commit more frequently?
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 […]
2004-03-15
RE: Proper Shutdown of SQL Servers in a Cluster
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
2003-07-16
Blogs
What Do I Do to Relax?
By Steve Jones
I’ve republished an editorial today from another author, called What do you do to...
Daily Coping 9 Dec 2022
By Steve Jones
Today’s coping tip is to find out something new about someone you care about....
Advent of Code 2022
By Zikato
Foreword Advent of Code is an annual event in which participants solve a series of...
Forums
SSRS - Add end date for all SSRS subscriptions
Hi, Could you please advice if it is possible to add an end date...
blank page
Hi guys! The topic "Connect to SQL Server with Python to Create Tables, Insert...
Ask SSC