Viewing 15 posts - 661 through 675 (of 3,232 total)
OK, here's what the blog is referring to.
First, set up a package level string variable for your sql command and a variable for each of the parameters that you'll be...
February 9, 2010 at 4:48 pm
Duplicate thread, please add replies here
February 9, 2010 at 4:26 pm
You can backup a database or a filegroup, but not at the table level.
You can organize your tables into filegroups if you need the ability to only backup certain groups...
February 9, 2010 at 4:25 pm
Cool. I have a good friend that puts in about that many in a year as well. He ran Boston last year for the first time.
The...
February 9, 2010 at 11:37 am
I thought I'd jump in and do the second 1/2.:-D
I'm going to do the Lincoln, NE 1/2 marathon.
So have you run a marathon before?
February 9, 2010 at 11:24 am
CirquedeSQLeil (2/9/2010)
John Rowan (2/9/2010)
marathonare you a marathoner?
Started a 12-week training program yesterday to do my first 1/2 marathon.
February 9, 2010 at 11:11 am
Your question is one that is often asked and debated. Check out this link:
http://www.sqlservercentral.com/Forums/Topic848551-360-1.aspx?Highlight=%22my+first+article%22
February 2, 2010 at 3:25 pm
Jeff Moden (2/1/2010)
John Rowan (2/1/2010)
Best practice is to index your FK columns for join performance.
CREATE INDEX <index name> ON <table name>(<column name>)
The FK's should probably be on the PK of...
February 2, 2010 at 10:29 am
IGNORE_DUP_KEY is an index option which means that you have to define it when you create your unique index or primary key.
I would recommend leaving the default option of IGNORE_DUP_KEY...
February 1, 2010 at 4:12 pm
You can set up a connection manager object using the OLE DB data source provider for Oracle. You will use the attributes that you've shown to set up your...
February 1, 2010 at 1:56 pm
See BOL for the full list of options for the CREATE INDEX statement.
February 1, 2010 at 1:45 pm
Viewing 15 posts - 661 through 675 (of 3,232 total)