Here is a way to find all XSPs in a user-database that were not delivered by Microsoft as part of the base installation of SQL Server:

SELECT *

FROM ...

Instead of Maintenance Plans, check out Ola Hallengren's SQL Server Index and Statistics Maintenance. I started using it about a year ago and have never looked back at MPs.

From Guidelines for Performing Online Index Operations:

- Clustered indexes must be created, rebuilt, or dropped offline when the underlying table contains large object (LOB) data types: image, ntext, text, varchar(max),...

Sorry, most of my Classic ASP skills fell off the queue a long time ago...in your example, is this:

replace(string, "'","''")

referencing an ASP function you're calling...

kennethigiri (3/22/2012)

---

Hi All. I keep seeing the following line in all Security Best Practices documnets:

•Disable COM components once all COM components have been converted to SQL CLR.

How can I disable...

Thanks, Tom. Granted, I have little to none of the nitty-gritty details but from what you have told us it sounds like it could have been done using T-SQL. I...

It's an interesting comment...scientifically prove. I take it as a given that if all data accessed does not fit in RAM allocated to uour buffer pool then expanding the size...

samareshmaity (3/22/2012)

---

Dear Friend,

My another Question, can i partition a table in sql server 2005...

SQLRNNR is pointing out a non-standard scenario where you may have an SQL Native Client alias setup, or have a Registered Server setup with a name other than your instance...

MEDESKTOP\GARY is what is known as your "instance name". The fact that your username is also Gary is only a coincidence. Instance names are chosen when installing SQL Server.

On my...

This is very general, is it safe to assume you are just starting out using SSIS? This series is great, and has been helpful Stairway to Integration Services[/url]

NewBeeSQL (3/22/2012)

---

My requirement...

The SSMS Tools Pack has a built-in feature to help you generate INSERT statements from a table, or even from a specific query...very handy.

SSMS Tools Pack > Generate Insert statements...

gravy1nt (3/14/2012)

---

First post so sorry for the Noob questions!

I am experimenting with solving a bill of materials (recursion) problem in SQL Server 2008.

Technical issues:

1. Within Visual Studio, how do I...

That's precisely the point! It is imperative that parallel testing be done. The SSMS Query Designer is a shortcut to gain a starting point without rewriting all syntax by hand....

Nice tips, thanks for posting back!

Just curious, can you describe (without disclosing anything confidential of course) the "complex processing" you are doing in your CLR object that made you decide...