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
- Interests: Performance Tuning Database Servers, Running and Coffee
SQL Server - Generate SQL INSERT from Excel
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
SQL Server – Error Logs recycle without SQL Server Restart
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
SQL Server - BACKUP LOG WITH NO_LOG
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
SQL Server – Modifying Production Data Good Practise
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
SQL Cachestore flush
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 Excel to HTML
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
SQL Performance Tuning - optimizing for response time
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 is misunderstood
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
SQL Agent Jobs – Schedule in seconds
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
Blogs
Removing a PowerShell Array Element–#SQLNewBlogger
By Steve Jones
I saw an article on this and realized I had no idea how to...
PostgreSQL Backup Failure
In this blog post I wrote a tip about fixing the PostgreSQL backup failure...
Dynamic Data Masking – SQL Server
By Tim Radney
Use Dynamic Data Masking to protect your data The post Dynamic Data Masking – SQL...
Forums
Lead Updates Not Working, Only Rendering Nulls
I hav a table that holds sports betting lines that i am using in...
Case statement to insert a new line in query output??
Hi I need to insert a new line of my output when a condition...
Ask SSC