pop022 (9/20/2010)

---

I was informed that there were a couple of changes between SQL Server 2000 and SQL Server 2008 that could negatively affect the performance of queries that were ported...

Ananda-292708 (9/20/2010)

I already have 10 developer license which my team is using on there individual laptops/desktops.

I have got a new Web project where i am planning to install a developer...

It usually remembers the last backup filename used to do a manual backup (log or full).

Dan H. (9/17/2010)2. Do you...

The best advice I can give you....READ THIS by Paul Randal....:-)

Myth #12: tempdb should always have one data file per processor core.

dibbydibby (9/9/2010)

The $ErrorActionPreference is set to stop. So even though I can get it to fail, this failure does not cause the SQL job to fail. How can I trap...

You probably have a conflict in a field size. Check to make sure if you are importing data in that your fields are large enough to accept them.

Some more information...

I don't mess much with CONVERT statements in T-SQL but should you not be specifiying the length of VARCHAR?

WHERE CONVERT(varchar(10),HOLIDY,101) = %var%

If your complete query works when you are in...

Add the set commands inside of the -Q parameter. You might want to do it as a Script.sql file instead. Put your query in a file and then use...

I have only sat the 70-432 exam and I actually tried using Microsoft Exam kit. The practice exams are good but the content in the book has not been updated...

If you do see that all of your applications are using Windows Authentication and not SQL you...

The counters are specific to the instance they are monitoring. I don't know that I have ever seen them conflict with another instance.

If you just applied SP3, how long has...

Same response as Gail: Which counter in Perfmon are you using?

SQL Server 2005 DMVs include a sys.dm_os_performance_counters that allows you to read in the counters that are added with the...

If you are a keyboard shortcut person, as I am:-D, you can also use the keyboard shortcut CTRL + G that will bring up the "Go to Line..." prompt.

Any reason why you have not applied SP3 for SQL Server 2005?

SQL Server 2005 SP2 backup failing[/url]

never mind miss read this article.