OPENQUERY does not allow variables, only literal/static queries.

Try code below instead.

--temporarily add "TOP (100)" to the query for testing purposes

SET @tsql = STUFF(@tsql, CHARINDEX('SELECT', @tsql) + 6, 0, ' TOP...

Eirikur Eiriksson (8/1/2014)

---

ScottPletcher (8/1/2014)

---

If the table may or may not exist, you'll have to make references to that table only in dynamic SQL. Otherwise, if the code runs and...

If the table may or may not exist, you'll have to make references to that table only in dynamic SQL. Otherwise, if the code runs and the table does...

Agreed, nice code.

But if it's a birthday, wouldn't it be reasonable to use the current date + 1 as the cutoff, since there won't be future birthdates but someone could...

SQL Server provides a stored proc, "'sp_spaceused", to return space info. But annoyingly and frustratingly, it returns two separate result sets.

For my use, I cloned their proc, adjusting it...

Books should be more valuable than classes. Look for titles by Kalen Delaney particularly. For general SQL skills, look for Itzik Ben-Gan.

Shrinking the log file has absolutely no affect on the data indexes and their fragmentation. You would only need to check on index rebuilds if you shrink the data...

I suspect it's because SQL's internal processing does "ON" clauses before WHERE clauses.

Therefore, I think they figure the ON clause might eliminate rows sooner than a WHERE clause, and avoid...

Sean Lange (7/30/2014)

---

ScottPletcher (7/30/2014)

---

That's not true....

That's not true. The default...

matt6749 (7/28/2014)

---

One followup. (Hope I'm not annoying everybody):

With the Simple recovery model I'm using, would BEGIN TRANS and COMMIT statements help free up space in the log when used as...

All clustered keys must appear in all nonclustered indexes. If you don't explicitly specify them, SQL will add them automatically.

I explicitly specify them when the index function requires them,...

Yeah, would have to see the main SELECT to know how to adjust the code properly.

Generally, you prefer 10ms or less, although up to 20ms is ok. Anything over that is poor and progressively getting worse, of course.

Again, in general, 100ms is not acceptable,...

Yeah, I'm completely lost as to what the code is trying to code. And if the db is offline, you won't be able to access the view "sys.database_files" within...