Table Size and Missing FK Indexes
I am bringing an oldie back with another twist. I recently ran into the need to correlate information between a couple of different queries that I like to use....
2012-03-14
4 reads
Blog Posts
Understanding the concept of SQL Server Failover Cluster
Before getting hands on experience in SQL server on failover cluster , I used to read many article about failover clustering. Unfortunately...
2012-03-14
17,384 reads
A Quick Introduction to Data Compression in SQL Server 2008
There is one thing every DBA knows with certainty, and that is that databases grow with time. MDFs grow, backups...
2012-03-13
2,002 reads
Command Prompt connectivity –U option
When you try to connect to sql server using isql/osql or sqlcmd there are two authentication you can use windows...
2012-03-13
523 reads
DBA supertech . Specialise or generalise?
Specialise or a generalise? It all depends on how you define these terms.
A SQL Server DBA may be considered to...
2012-03-13
745 reads
Houston Area SQL Server User Group Presentation
Thanks to everyone who attended my presentation “Scaling SQL Server to HUNDREDS of Terabytes” at HASSUG.
Here is the PowerPoint presentation: Scaling SQL...
2012-03-13
711 reads
Parsing T-SQL – The easy way
UPDATE 2012-09-12 : For my latest adventures with TSQL Parsers please see this post
Every once in a while, I hit an issue...
2012-03-13
11,073 reads
SQL Server 2012 Books
SQL Server 2012 was released to manufacturing last week, you can download it from MSDN if you have subscription or...
2012-03-13
2,182 reads
Synchronizing subscriptions in SQL Server Express
I was recently asked about synchronizing a Merge pull subscription in SQL Server Express using RMO, the lack of a...
2012-03-13 (first published: 2012-03-12)
4,291 reads
T-SQL Tuesday #028 - I'm a Jack of All Trades, and Proud of It
If I wasn't, would I have proposed the following topic for several speaking chances, including SQLRally?
Being a specialist means you're...
2012-03-13
1,457 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers