2019-11-01 (first published: 2017-09-11)
5,205 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
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers