SQL server – ISNUMERIC and checking for valid numeric tyopes
During a large ETL process from a staging table , UPDATE was creating an error on a CONVERT.
Msg 245, Sev 16,...
2012-01-30
1,052 reads
During a large ETL process from a staging table , UPDATE was creating an error on a CONVERT.
Msg 245, Sev 16,...
2012-01-30
1,052 reads
Generate SQL Server INSERT statements with Excel Concatenate.
A developer requested access to a Production database. The details were to COPY...
2012-01-27
1,059 reads
If some long running error situation , the Error Log can become very big. In those situations , it can be time-consuming...
2012-01-26
719 reads
The BACKUP LOG WITH NO_LOG and WITH TRUNCATE_ONLY options are discontinued in SQL Server 2008.
There is no replacement for this...
2012-01-22
2,557 reads
Q. “I need to modify Production Data directly on a Production database. What are some steps I can follow to...
2012-01-21
992 reads
For each cleared cachestore in the plan cache SQL Server reports a message in the error logs , such as :
SQL...
2012-01-20
1,151 reads
SQL Server, Powershell and Excel are a good mix . But saving to Powershell output to HTML is versatile – if requiring...
2012-01-19
840 reads
Different queries are optimized for different objectives
Response Times and Throughput are two standard objectives.
Response Time is about retrieving the hits...
2012-01-18
836 reads
Hungarian notation refers to a identifier naming convention. The variable indicates the variables use – as opposed to what they are....
2012-01-17
938 reads
1) How can I execute a SQL Server Agent Job every few seconds? Administrators try to use SQL Server Agent as...
2012-01-16
1,802 reads
By Steve Jones
incidental contact high – n. an innocuous touch by someone just doing their job...
My company is moving from an Azure PostgreSQL single server to a flexible server....
By Steve Jones
The survey is out now and you can share your experiences for a chance...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Comments posted to this topic are about the item How to Add a New...
Comments posted to this topic are about the item Knowing What You Don't Know
How can I tell from T-SQL if I'm connected to SQL Server or Synapse Analyics?
See possible answers