Thanks Randeep!

Although I am not doing anything with Filestream and FileTable yet, I will definitely try this out.

Hi Adam,

Thanks for taking the time to write!!

I have seen a Conditional Split used to do this.

RowNumber % 4 == 0

RowNumber % 4 == 1

RowNumber % 4 == 2

RowNumber %...

Great article! Really well written!!

Thanks for the script. I added it to my briefcase.

I noticed you are sorting by column numbers instead of names. This is considered a bad practice as it is not...

Nice Nicholas!

I use similar queries to prioritize what is going to be done during my maintenance windows.

DBCC CHECK the DBs that haven't been done in a while or ever. Same...

Thanks!

Here's a way using TSQL

SELECTLastServerStartDT= DATEADD(SECOND, -1 * (ms_ticks / 1000), GETDATE())

, LastSQLStartDT= sqlserver_start_time

FROMsys.dm_os_sys_info

Thanks for taking the time to help!

The comparison is done with the...

LOL Jeff.

RBAR is good when reading posts. 😛

Could you please demonstrate.

I know this is an old thread, but I want to share anyway.

The function uses schemabinding to make the computed column persisted.

USE TempDB

GO

IF OBJECT_ID('TempDB..#Test') IS NOT NULL

DROP TABLE #Test

GO

IF OBJECT_ID('dbo.ufn_GetHighestVal',...

Nice article thanks!

I've made that mistake before and seen others make it. It can be tricky to detect.

A colleague told me of a nifty trick today.

When releasing a trigger into...

Nice article.

I use cursors reasonably often for administrative task.

Somewhere along the line I picked up a misconception. I though LOCAL and FAST_FORWARD were defaults.

LOCAL might be the default if it...

Thanks Mark, that did the trick.

Here's what BOL says about using CONVERT with VARBINARY

Hi Chris,

Thanks for taking the time to post a reply. 🙂

What's the magic going on behind master.dbo.fn_varbintohexstr? Not just a CAST or a CONVERT I think.

pkapas (12/29/2014)

---

Quick question. I read this in the article: "Don't nest the views and join views to views"

If you have to rely on getting data from a previous view in...