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,047 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,047 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,055 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
712 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
1,621 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,134 reads
SQL Server, Powershell and Excel are a good mix . But saving to Powershell output to HTML is versatile – if requiring...
2012-01-19
833 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
832 reads
Hungarian notation refers to a identifier naming convention. The variable indicates the variables use – as opposed to what they are....
2012-01-17
909 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 can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers