These days I work with a data warehouse solution, based on partitioned tables. We set it at 100%, reindex the fresh partition at the end of each ETL run, and...

Adam,

That was one job, four years, and a SQL Server version ago, and I really don't recall the details. It sounds like you're working with SQL 205, and I am...

Where I currently work, we have a lot of dynamic code generated and run from within stored procedures (for good reasons, but don't ask--you really don't want to feel my...

Can you post a CREATE TABLE script for the table that you are working with? It'd be easier to show examples with something you are familiar with.

Philip

Table partitions (in SQL Server 2005 Enterprise edition) only support "static" partition boundaries -- that is, the value that the partitions are based on can't change once they're set up....

Assuming one table with five partitions (data for one year in each partition), with the data of each partition stored in its own file group, and assuming you've just received...

Turns out this was due to a table partitioning-related bug that crops up somewhere/how when a new partition is added to a table. As per PSS, this bug was fixed...

I ran it on my box sight-unseen, no problems. I was in the master database, and from an SSMS query window just ran

xp_msver

without EXECUTE, sys., or...

I think you got it wrong. Isn't the right question "Which version of Windows Vista is compatible with SQL 2005?"

Philip

If during an interview I were asked a question, gave an answer that I knew to be 100% correct, and was told I was wrong, well... during a job interview...

As Michael said, msdb..sp_start_job will start the job asynchronously. Getting your code to wait for the job to finish and check the return/exit status is very non-trivial, and possibly not...

I wish I were in Hawaii -- here in Chicago, temps are in the single digits, and negative with wind chill.

Philip

I believe it's a setting in a config file, for jTDS or Hibernate, or possibly a setting within Hibernate for a set or class of connections--definitely it was ON for...

I used SQL Profiler a few months back to pull out Deadlock information. While I'm not entirely sure what your current issues are, I'm hoping that some of this will...

Some thoughts after reading all the above:

If I'm reading it right, the passwords are stored within a table in a user-defined database in encrypted form, right? Is the encryption...