Good question and learnt something after hunting through articles on the web. I love doing research like this!

Nice question - confused me at first until I realised no key was being created in table 2.

This type of question really shows that's it worth reading something carefully!

k.subramanyam1017 (5/21/2012)

---

Hi friends,

could u please any one tell me the these questions

1) what is your company file architecture and how much data u r handle.

2) how...

I think this last group of posts shows that there are several ways to attack this (including my inefficient loop).

pnpsql (5/15/2012)

---

i need to parse a string like

[p]a]a]s]s][p

when a [ sign occurs then next letter need to be convert in upper case and when a ]sign occurs the

next...

One way I have accomplished this in the past is to store the parameter in a table and alter the stored procedure to read the parameter from the table.

As far...

rd_dart (5/2/2012)

---

Hi,

I have a query regarding SQL Server. Currently I am using SQL Server 2005 Express and I have a couple of databases for various clients. This database is hosted...

Have you had a look at RedGate SQL Monitor or the Idera products?

They both provide a good set of admin tools for reporting of disk, CPU and memory but I'm...

Good question thanks. I must admit though my answer was more luck than judgement but hey, I've learn't something too!

Thank you all again for your feedback - ISNULL and COALESCE befuddled me for a while!

Thank you all for the comments and especially to Hugo.

I love SQLServerCentral.com - I learn something new every day and the help and assistance of other members is readily available.

Great article Jeff. I used the splitter today to break apart filenames - amazing performance for our test runs. Can't wait to let it loose across the live data on...

Take a look at http://sqlserverperformance.wordpress.com/2010/03/08/easy-ways-to-detect-io-pressure-in-sql-server-2008/ for some examples.

Microsoft don't support other browsers very well when it comes to SSRS - I've had no end of issues with rendering, buttons not appearing etc.

It's a cheap way out but...

Hi Lee,

The Firebrand page is interesting, especially the statement "You’ll be T-SQL trained in just 2 days"; I've been using SQL for a few years and am learning new things...