Hi,

all the answers can easily be found in BOL (aka "SQL Server Books Online" in the "Documentation and Tutorials" folder of your SQL Server installation).

Example:

Question 1) looking for "clustered indexes,...

Hello James,

I'm sorry for confusing you but I have to correct the code I provided - even though it seems to work.

Reason:

I just run across Barry's statement regarding the use...

Hello James,

I'm sorry that I didn't include some more information about the Tally table in the first place...

The article mentioned above is one of my favorites on how to use...

Hi,

based on the split function as stated in the following post

http://www.sqlservercentral.com/Forums/FindPost451474.aspx (which requires a tally table)

I did some modification to that function to cover the order of appearence in the...

Hi Musheik,

another option to consider could be the use of XML format to transfer the data. Maybe your JAVA folks will look into this easier than extract into a a...

At your company, who is currently in charge for maintaining CIA (Confidentiality, Integrity, Availability of data) an who will be after granting production access to developers?

If the DBA group is...

Isn't any kind of ranking a subjective decision unless there are ranking rules that are widely accepted?

Based on that I think in a forum like this one there are at...

From my point of view any type of best (or recommended) practice does not need to be mentioned as an "entry requirement for requests" unless there is any "reward" for...

Lynn Pettis (2/24/2009)

---

Alvin Ramard (2/24/2009)

---

Yesterday was an interesting day on here. I don't think any of the posters were picked on, except for a quick reference to a White.house...

"There have been times it has seemed pointless to continue, but it is those 1 or 2 threads where the OP finally gets it that truly makes it worth it...

Post #645325

Hi folks,

sorry to post my reply to Lynn's "RFS" (request for sainthood) that late but I had to do some research and also had to BABELate my thoughts...

I think it's time for Paresh to get a little more specific...

Several possible solution were posted, each one depending on the circumstances of usage.

E.g. Barry's solution in my opinion...

Hi,

using the current system time to get a unique value is dangerous if the underlying server follows DST (daylight saving time).

What happens if you generate a key around the switch...