Viewing 15 posts - 676 through 690 (of 3,232 total)
Best practice is to index your FK columns for join performance.
CREATE INDEX <index name> ON <table name>(<column name>)
February 1, 2010 at 1:39 pm
I would recommend making sure you have your trace configured correctly. The trace will capture all SQL activity. All changes to data whether from SP, trigger code, or...
January 28, 2010 at 10:41 am
You'll need to write a function to do this. Here's a great ready by Jeff Moden on the subject:
January 28, 2010 at 9:57 am
Have you run a SQL trace? That should tell you exactly what is updating your column values to NULL.
January 28, 2010 at 9:53 am
David Lester (1/22/2010)
And it seems to suprise many, I have never even been on a farm, cause there is more here than farms... well here specifically there...
January 22, 2010 at 10:30 am
OK, I mocked up an example based off of this table:
IF OBJECT_ID('dbo.SSISTest') IS NOT NULL
DROP TABLE dbo.SSISTest
GO
CREATE TABLE dbo.SSISTest(
Name varchar(10) NULL,
Value int NULL
)
GO
INSERT INTO dbo.SSISTest
SELECT 'Ab1',23 UNION ALL
SELECT 'Ab1',25...
January 21, 2010 at 2:52 pm
grovelli-262555 (1/21/2010)
What are Synonyms?
From BOL:
A synonym is a database object that serves the following purposes:
Provides an alternative name for another database object, referred to as the base object, that...
January 21, 2010 at 9:01 am
Are these roles that you have created from scratch or are you trying to alter the permissions for the pre-existing database roles?
See this link http://www.sql-server-performance.com/faq/cannot_grant_permissions_to_special_roles_p1.aspx
As far as listing out SYNONYMS,...
January 20, 2010 at 3:11 pm
Sandeep Sharma-452981 (1/20/2010)
How to use User defined variables in SendMailTask for SMTPConnection
You wouldn't use it to set the Send Mail task, you would use it to set the SMTP Connection...
January 20, 2010 at 2:54 pm
The short answer is 'Yes' a script task can do this. You would first ensure that the data is ordered properly, declare a package variable as the counter, a...
January 20, 2010 at 2:49 pm
Viewing 15 posts - 676 through 690 (of 3,232 total)