Steve Jones - SSC Editor (7/15/2016)

---

It's a strange inconsistency, in my mind. We put all objects in sys.objects, except a few like Types. So we can have naming collisions. If...

There is dbid column in sys.dm_exec_sql_text

This should be faster (if your WHERE clause indeed includes first columns from the index where Date is mentioned):

SELECT TOP 1 @MaxDate = Date FROM Table1

WHERE {Conditions on init...

I'd suggest triggers on the tables FOR...

Then, there...

Who is that poor guy who's meant to read through those 300k lines of this report?

Considering 60 lines per screen it's 5 thousand of screens to look through.

And if it's...

SELECT *

INTO #TempTables

FROM tempdb.sys.objects o

WHERE o.type = 'U'

GO

DECLARE @Table TABLE (id INT, Name NVARCHAR(50))

SELECT *

FROM tempdb.sys.objects o

WHERE o.type =...

Grant Fritchey (7/20/2016)

---

e expressions can be reused multiple times in a query or even called recursively, as Gail already noted. Derived tables are just a query that gets treated as...

You do BACKUP LOG...

ben.brugman (7/19/2016)

---

I tried a number of setup's. Temp tables were slower than persistent tables.

That's odd.

It should not be like that.

Tempdb is normally setup to be the fastest database in...

ben.brugman (7/19/2016)

---

The information of a folder is aquired using xp_cmdShell.

Reading of individual files is again done using xp_cmdShell.

After that the file is parsed into independend fields.

This involves splitting the string...

You can still backup and restore logs.

Just ship to other sites them using different tools, say, robocopy.

You must use

'TW' COLLATE {same collation as defined for PROVID}

Because it's not a single-user environment.

Because a process...

You better use log shipping.