Selecting a tool before fully understanding the problem is not very clever!

😎

Quick questions,...

Quick solution utilizing a recursive CTE, fine for small sets but I suggest you have a look at Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets[/url] and...

makis_best (4/12/2015)

---

Hi

I have a table with records like that.

Group | Value

Team 1 | 0

Team 1 | 0

Team 1 | 1

Team 1 | 1

Team 2 | 0

Team 2 |...

The row size is roughly the...

rajemessage 14195 (4/12/2015)

---

hi,

I am making one big table which will have good no of cols,

There is one critaria that is, to seepd up keep the lengh of row less than...

rajemessage 14195 (4/11/2015)

---

hi,

"So, what does that mean for index columns order? Quite simply, if queries are always going to filter with one or more equality predicates and one or...

Further on pietlinden's...

Two suggestions, first one is counting by subtracting the length of the string after removing all the X characters to the original length of the string, the second one is...

Grant Fritchey (4/11/2015)

---

Since no one else pointed it out, I sure will:

WHERE (dbo.CLI.CLITYPE LIKE '%A%') AND (dbo.SVAC.PROGNO LIKE '%286%' OR

dbo.SVAC.PROGNO LIKE '%288%' OR

dbo.SVAC.PROGNO LIKE '%289%')

That is going to lead...

Jeff Moden (4/11/2015)

---

robertharrison (3/25/2015)

---

The following was found as a solution to detecting non-printable characters in a string. I can find no explanation of how the COLLATE function is used.

Can...

sql-lover (4/11/2015)

---

Eirikur Eiriksson (4/11/2015)

---

sql-lover (4/11/2015)

---

Grant Fritchey (4/11/2015)

---

As far as I know, if you have to have a guaranteed, 100% accurate, count of the rows in the table, the way to...

MotivateMan1394 (4/10/2015)

---

Hi

We should monitor Database Objects created by development dept.

in 2 views :

- View , sps , .....

sql-lover (4/11/2015)

---

Grant Fritchey (4/11/2015)

---

As far as I know, if you have to have a guaranteed, 100% accurate, count of the rows in the table, the way to do it is...

Does anyone have an idea on how to solve this problem?

😎

Quick thought, it is going to be somewhat tricky to correlate the actual tempdb I/O to an execution, here is an example alternative that checks for # or tempdb in...