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,050 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,050 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,057 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
714 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,232 reads
Q. “I need to modify Production Data directly on a Production database. What are some steps I can follow to...
2012-01-21
989 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,140 reads
SQL Server, Powershell and Excel are a good mix . But saving to Powershell output to HTML is versatile – if requiring...
2012-01-19
834 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
834 reads
Hungarian notation refers to a identifier naming convention. The variable indicates the variables use – as opposed to what they are....
2012-01-17
930 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,797 reads
By Steve Jones
I saw an article on this and realized I had no idea how to...
In this blog post I wrote a tip about fixing the PostgreSQL backup failure...
By Tim Radney
Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...
I hav a table that holds sports betting lines that i am using in...
Hi I need to insert a new line of my output when a condition...