In case anyone was curious, the issue here was that 'see' is a system stop word. A full list of system stop words can be obtained by running the...

The entire body of the procedure I'm using is:

CREATE PROCEDURE [dbo].[usp_RebuildIndexes] (@DatabaseName varchar(255))

AS

SET NOCOUNT ON;

DECLARE @objectid int;

DECLARE @indexid int;

DECLARE @partitioncount bigint;

DECLARE @schemaname nvarchar(130);

DECLARE @objectname nvarchar(130);

DECLARE @indexname nvarchar(130);

DECLARE...

Thanks for the response - I should note the script isn't entirely home made, I picked it up from MS and altered it slightly to fit our needs.

Also, I'm not...

Right - I was still getting the seek even when I explicity declare a parameter as a nvarchar and used that to query my nvarchar field, like he did in...

Our developers use nHibernate here and we also use a collation of SQL_Latin1_General_CP1_CI_AS, so I was curious if I would be able to reproduce this same issue. We actually...

Haha this was a good one, had me fooled.

Right, thanks Steve. My whole motive behind getting a certification is simply to learn and at the end feel like I know more than I do now. I...

Thanks to everyone for all the input. I'm looking for a way to enhance my resume and to prove that I spend time outside of work learning about SQL Server...

Right, I would never ask for a brain dump. To me the benefit of getting a certification would be the preparation that goes into it and learning that comes...

Hey Steve,

At home every morning, I check my work email via my smart phone while having my breakfast and coffee to see if scheduled jobs failed or if developers/end users...

What about the 'import column' function in SSIS? Does anyone know anything about this feature and if it would be faster than a bulk insert?

Here's a link for reference:

Again, the column where the data is held has filestream enabled, so the actual data will not be stored in the database, storing only the paths is not an option...

Hi Wayne,

Thanks for the response. Correct, I have one flat file that contains a list of paths to other files that need to be loaded into SQL Server. ...

Nevermind, I've figured it out. Thanks again for the replies.

I haven't used expressions much - could one of you explain how to use the variable I created that is storing the database name as an expression that I can...