In case anyone missed it, here's a good article on the (non) dangers of xp_cmdshell:

Tech Corner: xp_cmdshell isn’t evil[/url]

by Jennifer McGowan

It's really a pity that Microsoft abandoned IronPython and pushed PowerShell (even though I can't confirm that the two decisions were coupled in any way). The former is still...

One thing that seems to be sometimes overlooked is system databases -- specifically agent jobs in msdb but also IS packages for non-SSISDB packages. Then there are SSISDB, MDS...

FWIW:

DECLARE @i VARBINARY = 0x0005432345544

select LEFT(@i, 3), LEFT(CONVERT(VARCHAR(64),@i),3), LEFT(CONVERT(VARCHAR(64),@i,1),3), LEFT(CONVERT(VARCHAR(64),@i,2),3)

produced:

(No column name) (No column name) (No column name) (No column name)

...

trimjib (11/2/2015)

---

As Ryan pointed out the real problem is with the query dataset not being utilized for subsequent page calls. The cost is in preparing the dataset, not in grabbing...

OFFSET/FETCH is the prefered method for pagination, I believe

We usually build a zip file with folders holding the package and a deployment script that uses the dtutil command. The prod DBA just has to unzip the...

Its a bit more than a few, but just a bit! Its actually a pity we can't use F# for scripting (yet!) It would be substantially less code.

The other...

I just executed this against the AdventureWorks2012 database hosted by RedGate on Azure. I got one row. Changing the UNION to UNION ALL, I get:

(No column name)(No column...

I'm using the splitter (just downloaded the zip file) and noticed something odd. Dunno if its just me, but check this out:

select * from dbo.[DelimitedSplit8K](' ', ' ') split...

Like many things, "It depends".

Are the sps in the special db used across many databases? ==> keep 'em together (maybe even in master/programmability/stored procedures)

Are there sps in the special db...

+1

The question asks, "What happens", yet one of the "correct" answers is that we need to change the variable and replicate lengths. At the risk of being pedantic, this...

Please post CREATE TABLE statements for all the tables involved, some sample data for each as INSERT INTO statements, and the output you want to see from your join.

I don't think that's a Cartesian product. If it were, you would have 89 (8*10) rows of ouput.

A CROSS JOIN would give you a Cartesian Product