Great piece!

Meta Data / Extended Property question:

I have a PDF file (Man I hate PDF) that has thousands of details on Tables and columns for a very large DB (schema...

Jeff

Don't laugh but I'm not that familiar with Command line syntax and so I never thought about trying something like xp_DirTree. Do you know of any examples using xp_DirTree...

For one with SSIS knowledge/experience this probably is easier to do in SSIS. However if you haven't...

seshasai.n (3/1/2011)

---

Hi,

I dont think so, is it worked or not, better to use sp_spaceused system stored procedure in the cursor, or try to create a dynamic sql to find out...

I'm all for BEST PRACTICES so if there is a better way to do this then using the INSERT-EXEC method I'm open to trying it.

I use this now to...

As a frequent visitor of the procedural developer forums I can tell you that a good number of the developers in support of the NOSQL DB's do so because they...

Craig Farrell (1/31/2011)

---

YSLGuru (1/31/2011)

---

Thanks for the suggestion but do you know if there is an equivelant syntax that shows all...

UMG Developer (2/18/2011)

---

Nice little script, but it will return multiple rows for partitioned tables. Here is an updated version that takes care of that:

SELECT

o.name AS "Table Name",

...

Jeff Moden (2/14/2011)

---

YSLGuru (2/14/2011)

---

GOTCHA #1: The process we use to download an d import is proprietary and can not be altered so we can't simply not download the few files...

Jeff Moden (2/17/2011)

---

YSLGuru (2/24/2009)

---

corey lawson (12/5/2007)

---

So... the major problem with your article is that it posts no solutions for the problem at hand, or no pointers to where to look...

Thanks guys for replying with the suggestions. I actually stumbled across another method that I went with because of its ease of use. It does require using the...

Thanks for sharing ALZDBA but I think thats just for showing how long SQL Server has been running and not the uptime for the Windosw Server its running on. ...

Craig Farrell (2/14/2011)

---

Have you looked at the for each object in SSIS? Perform a loop using the file name's pattern to find all the instances, and then do what's...

PaUL

I have a follow-up question now that i read thru the article on Query Plans. I assume you have used this and if thats wrong please let me know.

If...

OK Paul I will read it through in it entirety this time.

thanks