Why All The Fuzz?
I really must thank Steve for his editorial on FizzBuzz. It seemed like a really good topic to do some...
2010-02-23
784 reads
SQL RNNR
I’m givin’ ‘er all she’s got!
Or am I?
As I proceed down the path on a consolidation project, I have taken time to pause and ponder...
2010-02-21
661 reads
May I help you?
With the Vancouver games underway, I have been reflecting on the 2002 Winter Olympic Games. Those were the greatest winter...
2010-02-18
818 reads
DBA.Sleep(8hrs)
I have been pondering recently what helps me to sleep at night. Or, conversely, what prevents me from sleeping at...
2010-02-17
1,317 reads
In Vs. Inner Join
This is tightly related to another of my forays into tuning some slowly/poorly performing processes. This process came across my...
2010-02-16
869 reads
PayPeriod II
I recently blogged about a solution I had decided to use in order to solve a problem related to PayPeriod...
2010-02-14
791 reads
Relationships
This month Rob Farley is hosting TSQL-Tuesday #3. The topic is Relationships and he has left it wide open for...
2010-02-09
872 reads
Log is Filling Up
Today I ran across Paul Randal’s latest post showing how to find open transactions and such. This is a nice...
2010-02-05
523 reads
Key Discovery III
In Part I and Part II of the series, I discussed documenting and discovering Primary Keys and Clustered Indexes. In...
2010-02-02
1,694 reads
Key Discovery III
Recursively traverse system views to build a Hierarchical Perspective into the database.
Related Posts:
T-SQL Tuesday Participation Over the Years December 19, 2018
T-SQL Tuesday #104: Just Can't Cut That Cord...
2010-02-02
5 reads
Blogs
Advice I Like: Training Employees
By Steve Jones
Train employees well enough that they could get another job but treat them well...
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
SQL Server Migration Overview
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Why Data Modelling Still Matters - More Than Ever
Comments posted to this topic are about the item Why Data Modelling Still Matters...
hops from sql server to mysql to s4 hana - possible?
Hi when i think of server hops , i think of how kerberos assists...
Question of the Day
Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers