You have created a partitioned index. you need to recreate the table on your partition scheme, or use the clustered index as the partitioned index.

Okay, for one thing your trigger will fail if more than one row was inserted. Think set-based. You don't need all those local variables.

All your trigger needs to do is...

First of all, if I wanted to collect data from multiple sources into one table as it occurs I would consider a service broker solution. This methodology is a...

text (character) data can be stored in a binary (or varbinary) data column. If its valid ASCII or Unicode encoded text it can be "converted" to char or text using...

Here is a select snippet that will return user and role permissions on objects in a database. I have a proc that I run every day that gathers logins, users,...

What Sean said except that i would provide an output value for both cases so that the output parameter is always set to some legitimate value:

CREATE PROCEDURE [dbo].[pr_insertAgencyVendorInfo]

( @ClientName nvarchar(15),

@VendorName...

The documentation is correct, the activation procedure is executed when a message arrives on the queue.

Of course this only occurs if the queue has activation enabled (turned on) and an...

If your recovery model is set to FULL and you are not doing T-log backups your transaction log will continue to grow, until eventually it will become larger than the...

Yes.

There are two ways you could go: replication (managed by SQL Server) or change your applications to interact with a middle tier that will perform the updates (and queries) instead...

azenon (6/5/2013)

Sorry if a stupid question but why is the primary data file still growing when a second data file has been added? I would like to not have the...

You can set up an alias on the client (SQL Native Client) via the client configuration tool.

There at still many unanswered questions such as what sort of disk arrays are configured, and how is tempdb and the application databases deployed on these arrays? What is...

Your question is very broad and we have no information about the databases, the queries being run, the OS (32 vs 64 bit) or the server hardware and disk layout...

The easiest way is to use OpenXML then you can basically use select statements against the XML table.

Read up on OpenXML in BOL you should be able...