My firend Remi schooled me on a trigger post a long time ago that dbcc inputbuffer now returns an Nvarchar(4000), and not 255 that i had assumed was still true...

row number is very handy for getting data like you are asking...this is a wild guess to get you started, it might or might not be right, but is a...

ulisseslourenco (8/9/2011)

---

In fact I...

no the task scheduler has an option to repeat multiple times:

you have to dig intot eh details just a little here:

ok i see there is a RID Lookup on the Company Table, which is a Heap, that seems to be something to address, I'm going to sit back and learn...

well, i'm pretty sure statistics need to be updated; we've got a couple of orders of magnitude off on the estimated vs actual on two of the index seeks:

i don't...

the errors pretty straight forward, i think:

you probably have an exchange server, and in the From Address of...

Frank Cazabon (8/9/2011)

---

I am using FILESTREAM to store PDF documents in a table. I let the user select the PDF to store and then use this code to upload...

don't forget Central Management Server is SSMS 2008...that allows you to run the same command on multiple servers.

In the end, each server will require a connection in order to pass...

on the other hand, I know of DBA's who have never used the DMV's at all.

Subjective Adapts covered the DBCC commands pretty well.

I dunno, would you say that a...

you mean a binary representation/bitmap, i guess?

i've got this saved in my snippets, but it's for 2005 and above because it's using a CTE.

you might be able to adapt...

ok...but why via email? why not just have them go to a web page that generates a dataset, and presents the results, based on data input of those people in...

bcp.exe OUT can export a table to a csv file, and then bcp.exe IN can import that file into the other server. you can use this method if the servers...

my first inclination is to see if there are any databases that are in FULL recovery mode, but have NEVER been backed up:

they probably have gigabite sized log files and...

6000 is pretty wide for a single username...is it a comma delimited list of names, or just an oversized column?

if you do max(datalength(ThatColumn)), what's the largest current value?