Tally Table - String Cleaning
Overview
This is something that most people eventually need for reporting purposes. This function uses a Tally table to 'clean' a...
2010-01-13
4,201 reads
Blog Posts
The Advantage of GUIDs
I never liked GUIDs, not really using them in most of my development until I had a conversation many years...
2010-01-13
688 reads
Why not play my cards?
Still no work on my laptop. It’s been over 24 hours since I left a message for the customer escalation...
2010-01-13
722 reads
Why not play my cards?
Still no work on my laptop. It’s been over 24 hours since I left a message for the customer escalation...
2010-01-13
720 reads
Finding Invalid SQL Logins
As many of you know the system stored procedure sp_validatelogins is used for finding invalid logins. Although sp_validatelogins is useful there's...
2010-01-12
5,069 reads
IN vs INNER JOIN
Often in forum threads discussing query performance I’ll see people recommending replacing an INNER JOIN with an IN (or recommending...
2010-01-12
21,569 reads
Installing SQL Server 2008 and 2008 R2 on Windows Server 2008 R2
There is a recent post on the Microsoft SQL Server Support Blog about how to get SQL Server 2008 and...
2010-01-12
1,473 reads
Installing WordPress
Last week I posted about Picking a Blog Platform on some of the process that lead to me moving to...
2010-01-12
743 reads
Intel Intelligent Home Energy Management
Last week at CES 2010, Intel showed off a proof of concept device for a home energy management dashboard. This...
2010-01-12
990 reads
January OPASS Meeting Tonight
Tonight is the January meeting for OPASS and we have a great schedule for the evening.
Robert Hurwitz a developer for...
2010-01-12
382 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
Forums
BCA KCP Pejagalan No. Telp:083831617937
Whatsapp.083831617937 Jl. Pejagalan I No. 3E Jakarta Utara, DKI Jakarta, Indonesia 11240
BCA KCP Permata Kota No. Telp:083831617937
Whatsapp.083831617937 Ruko Permata Kota Blok A No. 10 Jl. Pangeran Tubagus Angke No. 170...
BCA KCP Pluit Kencana No. Telp:083831617937
Whatsapp. 083831617937 Jl. Taman Pluit Kencana Selatan No. 1-3 Jakarta Utara, DKI Jakarta, Indonesia...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers