kiran.chintala14 (5/20/2009)

---

I have a column of varchar(5000) in sqlserver but when i send the data of size more than 4000 characters as parameter to a procedure it is throwing...

TheSQLGuru (5/19/2009)

---

As an independent consultant (and knowing that you are newly so), let me paraphrase Robert Duvall in "Apocalypse Now": I love the smell of a train wreck in...

???????? :ermm:

You can add files of multiple disks to a filegroup, so disk size shouldn't be a problem.

Data will be spread over all files of the same filegroup (needs (clustering)...

I've seen udb sticks being used as sqlserver disk system for demonstartion purposes.

You know: a usb hub with 4 usb sticks on it, just to demonstarte hardware failure (pull out...

OP dated 04/2004 ?? 😉

another nice resource: http://sqlblog.com/blogs/paul_nielsen/archive/2009/05/09/why-use-stored-procedures.aspx

Post the procs DDL if your dev cannot find an optimal solution 😉

You'll have a good chance people over here will !

psangeetha (5/14/2009)

---

I've the same issue still going on.. At this stage, we just want to provide our clients with what they will need to do when the master key gets...

doug turner (5/14/2009)

---

I can see the mapped drive in Windows, but I'm not sure how to get SQL Server to see it. The link you sent is a big...

so .... after migration/implement of a new version of your dbs, things started going the wrong way.

Did you rebuild your databases indexes after the big maintenance ?

How are your current...

I thought he was beyond that point.

Off course that is the way to start any investigation !

HDMan,

Keep in mind your largest consumer may actually have a small avg...

and if you actually need speed....

- 64-bit

- CPU

- RAM

- SSD disk sistem (e.g. ramsan )

Start with asking a huge budget ( blanc cheque if you can :hehe: )

Check out topic "Readme_SlidingWindow" in BOL !

With partitioning, preparation is crucial !!

The one you already have is SQL Server Profiler ! ("C:\Program Files\Microsoft SQL Server\90\Tools\Binn\PROFILER90.EXE")

Start a trace and analyse it.

3th party tools:

- Quest software : Spotlight for SQL Server

- Idera :...

As Steve said : the password doen't need to be the same;

The backup password is used to encrypt the backup itself. Nothing else.

If your business applications connect providing all possible connection info (application name, workstation id,...) ....

those non-business application connections can easily be rejected using a login trigger and only allow...