The frequency will vary but it will be at least once a week I'd say but possibly more. Its used as our testing DB , something the developers, Training...

Jack

Unfortunately that iTVF did not work for me with the string of text I am parsing. I was hoping that perhaps it was just because I am not seeing...

Thanks Jack, thats what I was looking for.

Can you confirm the survey results are not linked to our login/profile? It does not apear to be however I have not logged off of SSC and then try...

While we’re on the topic of Running Totals..

Has anyone heard if the next iteration (or the one after) of SQL Server, SQL 2010, will include some kind of update in...

Jeff Moden (7/1/2011)

---

Craig Farrell (6/30/2011)

---

Jeff Moden (6/30/2011)

---

I don't know if it'll make people feel any better about the "Quirky Update" but Tom Thompson and Paul White added a couple of...

Thanks for the link. I have a possibly dumb question though. When testing the code out I ran into...

How about Trace Flag 902 ? ANy info on this one besides its preventing scripts from running during start up such as those from a service pack update or...

Additional note:

The SQL Server instance in question has UCP which appears to be what causes all the trouble. If disabling UCP on the server can enable this pain to...

1) I guess the pro-Cloud Pushers selling point about the Cloud always beeing available was a bit of a stretch just like every pro-cloud point they make.

2) The Cloud is...

For what its worth.... from my 'T-SQL Shortcuts' scripts I found the following:

/*Per SQL GURU Itzah-Ben Gah the fastest way to extract the date portion of a DateTime value is:*/

SELECT...

As someone who loves the benefits that virtualization offer, implementing VM across the board on everything simply because its whats hot and being pushed at the time is as bad...

henry.scott (6/16/2011)

---

I think the key point in the article is that most of this was dictated to the SQL guys. This seems to be the way these are done. There...

I'm involved in a somewhat frustrating case of "to reboot or not reboot" regarding some servers with our IT admins. I know the whole argument for why SQL Server...

bitbucket-25253 (6/6/2011)

---

a) On a recurring schedule

Using Google "sql server scheduled job"

You should get About 285,000 results (0.16 seconds)

b) without Using SSIS

Use Google "SQL Server Bulk Export"

You...