TRY_PARSE is the first place my mind went as well. A long-overdue feature of T-SQL. I rolled my own for 2008 using SQLCLR which I use within check constraints to...

You can achieve it through the use of WMI....

Jeff Moden (11/20/2013)

---

opc.three (11/19/2013)

---

Jeff Moden (11/5/2013)

---

Heck no....

jobudzin (11/20/2013)

---

That is what I was originally thinking, so then I am guessing I would need to create a brand new powershell script which encompasses the commands which I provided?...

Jeff Moden (11/5/2013)

---

Heck no. I leave...

TaylorMade (11/13/2013)

---

badOedipus (4/26/2013)

---

I'm posting on this old post mainly for completeness and to help anyone else out that has this same issue.

I'm not sure how far back this goes, but...

Nice question. We just went the route of genericizing some scripts using sqlcmd and having access to it within SSMS is a nice feature for developing those. Best of both...

The WMI query uses a wildcard so it will find files named with a datestamp. See LIKE 'BusinessData%'

SELECT *

FROM __InstanceCreationEvent WITHIN 5

WHERE TargetInstance ISA 'CIM_DataFile'

AND TargetInstance.Drive...

The WMI Event Watcher can present us with some seemingly unpredictable behavior. It is true that renaming a file to satisfy the mask will not cause the event to fire....

Please post your query.

And if possible, script out your entire database including statistics and histograms. Here is a walkthrough on how to do that[/url].

Very cool! Did you ever look into using Service Broker (SB)? I am sure there is much more nuance to the system and what it provides than what you cold...

Carl Waitz (10/25/2013)

---

My original query is from when I was first acclimating to SSIS with a Web Service which was still under development. I quickly found everything I needed at...

Staging tables are fine but they don't buy you much if you're eventually having to load into the final table anyway. If your dataset is clean reliable or you have...

Minaz (10/28/2013)

---

while inserting do my indexes are fragemented? Just by updating the index stat will not update the table and during maintenanace window I can ran the rebuild/reorg index job...

There are no hard and fast rules for this. You must test. It will depend on many variables. How many indexes do you have? How wide are they? What order...