Michelle-138172 (10/30/2015)

---

I've been searching info on sql server clustering for 2014 standard edition on AWS, but it hasn't come up with a lot of options. Are there not many companies...

Thanks Mr. Livingston. I just installed and played around with both of Jeff...

Phil Parkin (10/29/2015)

---

Alan.B (10/28/2015)

---

Hi folks. I needed to write a stored proc that takes generates a string of random characters @minlen to @maxlen characters long for testing some functions. What...

allnelsons (10/28/2015)

---

So, question about these splitter functions (which are pretty much the most used tools in my arsenal, btw!), are they faster/more efficient being run from the I.B.G. CTE tally...

an even correcter answer would be:

It depends

(5 with a case insensitive collation, three if the collation is case sensitive. )

if I move the Left outer join though out the join sequence I get different execution plans and execution times.

Depending on your table structure, moving the LEFT JOIN may change...

TEJABI (10/26/2015)

---

declare @str nvarchar(1000), @str1 nvarchar(400), @str2 nvarchar(500), @concat nvarchar(1000), @i int, @j-2 int

set @str = '$I10~TESTING1$XYZ$I10~TESTING2$ABZ$I10~TESTING4'

select @str1 = SUBSTRING(@str,CHARINDEX('$I10~',@str) +5,7)

select @j-2 = ( LEN(@str)

...

You create a dataset, do your query there, then reference the value of the dataset...

FYI Steve: this is a better link to the article:

http://www.informationweek.com/it-life/15-hottest-it-jobs-for-2016/d/d-id/1322321

What you posted is that link with "?image_number=1" at the end. That's the "first page of the list" and there is...

One way to get around this is to calculate the median before it get's to SSRS. For example, say you are getting your data from a SQL Server Stored Procedure...

First, I'm guessing that running the query with collate Latin1_General_CS_AS will be about three times faster than ignoring case sensitivity because you are returning more records. It's also worth noting...

Just to be clear: if @StartDate is November 28th, 2015 - you still want 11/6/2014? I think that's the case, just double-checking...

This is a little cleaner:

DECLARE @StartDate DATE =...

Jeff Moden (10/25/2015)

---

Just a suggestion and looking at the data, I...

I've been there. I was a DBA for about 5 years and worked in very different environments. It takes a tremendous amount of effort to be a good DBA; it...

The Quirky Update method (that Luis and Drew poster links for) is a good way to go.

It's also worth looking at Hidden RBAR: Triangular Joins[/url]. This article explains why...