Paul Hernández (5/3/2013)

---

Hi Folks,

I have a package that loads records in a CRM destination using a Web Service. This execution takes around let´s say 3 hours. I would like...

jhager (5/6/2013)

---

Thanks for replying; my supervisor and I were mostly concerned with the "who and why" with the sudden data growth, then later settling back to normal levels...as we didn't...

jordanovskibojan 74807 (5/5/2013)

---

Hello guys,

I have problem that I can't resolve ..

I want to make simple store procedure using .net 4.5 and I cant deploy my project ..

I have...

You may need to initialize the Subscription without a Snapshot or with special Schema Options such that the DDL is not affected on the Subscriber when initialized but other than...

Shrinking your data files is considered a bad idea unless you;re in an emergency situation. It fragments your indexes terribly and inevitably the files will likely grow to their original...

Are you rebuilding every index? Maintenance Plans do this.

Consider using a tool that inspects the fragmentation levels and only rebuilds indexes that actually need it. Here is a good...

From SQL Server 2008 R2 Diagnostic Information Queries by Glenn Berry[/url] you can grab a quick view of your highest CPU procs:

Find highest CPU use by DB:

-- Get CPU utilization...

At the Windows level I think you can intercept and prevent attempts by the sqlservr.exe process to spawn instances of cmd.exe. I am guessing this is done using WMI but...

Why?...

I think Wayne already called out that the comment was misplaced.

http://www.sqlservercentral.com/Forums/FindPost1046450.aspx

I thought you were taking things in a different direction.

How...

Are you sure you are looking for help with extracting DTS Packages (SQL 2000 technology) from SQL 2008? DTS Packages can be stored in msdb in SQL 2008 but it...

Mainly because it is native. One less dependency.

No, but you can search for *.zip and then use Precedence Constraints within your Loop container to run different paths of code based on the actual file name.

Nice job Lowell.