I hate sitting in an interview and having the dude ask me the stupid textbook interview question: where do you see yourself in five years? My answer is always: as...

How do we...

Does this still matter in Windows 2008? I thought...

Found the solution: ALTER VIEW on every view referenced by a data source in SSRS. Have no idea why this works, but it does work.

The "LastChecked" column should be updated regardless of the fragmentation percent. The procedure gets the frag percent for all indexes, updates the _IndexList table (with the LastChecked column), then only...

We are using ODBC. Tried using the TERADATA connection but couldn't get it to work. I don't think I'm using the right connection string, but I've tried about 9000 variations...

That would make sense, but no, none of the databases were deleted.

Yes - that is actually what I have (msdb.dbo.PNGCORP_IndexList) . That's how I can tell that the job isn't working on some days. The table has a LastChecked and LastReorg...

I am experiencing the same issue with SQL Server 2008 R2. The job will execute and you can see it in the history, but the run time is typically less...

True. It's the amount of data that we're putting into memory that matters, not the amount of times that we're querying the data.

With that in mind, I've created a...

Here is the table:

CREATE TABLE [dbo].[xxxLoadSimTable](

[datetimedata] [datetime] NULL,

[intdata] [int] NULL,

[floatdata] [float] NULL,

[varchardata] [varchar](50) NULL

)

Here is a sample line of data:

datetimedataintdatafloatdatavarchardata

2012-10-08 11:26:36.903216216.201080970516cuH26-bHR'=WbPhH9E`t1T=KTNVQa8>W#`jpKJ+Y;8kw^+|KZj

For the RAISERROR statement, the text can be anything you want. The severity is the highest severity number in the "can be corrected by the user" range (see http://msdn.microsoft.com/en-us/library/aa937483(v=sql.80).aspx for...

I think the problem was that fileNotify.fileexists is not a bit type. This should work:

DECLARE @Result INT

SET @Result = (

SELECT COUNT(*)

FROM fileNotify

WHERE...

Forget it - found the error. It's an issue with Visual Source Safe.

VS creates a \bin\debug\ folder in the local project folder. It looks like it copies the files to...

WE HAVE A WINNER!!!!

Thank you. It's the property that we all thought was useless with the advent of

Click on the Matrix, right-click on the little box the shows up...