Sorting a String as a Number with T-SQL and SSIS
I was working on a Cube in Analysis Services for a client recently and needed to sort on a field...
2012-01-23
3,800 reads
Blog Posts
Want to recruit me? Please follow these rules
I get 15-30 calls/emails a week from recruiters (not counting the dozens of auto-generated emails I get). Being a contractor...
2012-01-23
908 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,777 reads
SQL Server- Output clause
Output Clause:- The SQL SERVER 2005 gives us an Output Clause which gives us the information about each row affected by the...
2012-01-22
2,188 reads
SQL server the timeout period elapsed prior to completion of the operation
AdvertisementsSQL server clustering the timeout period elapsed prior to completion of the operation
Recently I faced one of our application could...
2012-01-22
16,173 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
1,007 reads
Database uplevel Restores Follow On
Today's post is a follow on from one earlier this month Database uplevel Restores. I got round to testing restoring...
2012-01-20
1,146 reads
DBAs and the Career-Life Balance
Reprinted from my editorial in Database Weekly.
I know a lot of DBAs who make SQL Server the focus of their...
2012-01-20
888 reads
Local Community Events & User Groups from Around Town....
Staying true to the meaning of SQL Community with respect to local chapters and user groups, I wanted to bring you...
2012-01-20
1,574 reads
Nooner Viewing Summary
Over the last few weeks, I’ve been watching SQL Server videos and webcasts. My primary motivator in doing this is...
2012-01-20
594 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Alamat kantor BCA KCP Brebes Telp:0818751777
WhatsApp:0818-751-777 Jl. Pangeran Diponegoro No.296, Brebes, Kec. Brebes, Kabupaten Brebes, Jawa Tengah 52212 (@bcakcpbrebes)
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers