events

RE: DB Backup

• by Kishore-132325

• PASS

• Reply

You cannot do inidividual object backup/recovery in sql 2000.You need to take full backups.

2004-03-22

RE: Create Table Link using T-SQL

• by Dinesh Asanka

• SQLServerCentral.com

• Reply

Thankx Steve Hicks for the promt help 

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2004-03-22

RE: Stored procedures are BAD...a philosophical question

• by bp

• SQL Saturday

• Reply

hmm.. I also typed up a long response to this but it is not showing up after I click the post button (kinda frustrating).anyways, stored procedures are good because they improve upon the use of execution plans because they parameterize its queries.  first time you hit stored procedure, there is slight additional overhead but performance […]

2004-03-21

SQL Server 2005 Feature Survey Results

• by Brian Knight

• SQL Saturday

• Topic

Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/bknig

2004-03-21

8 reads

RE: BigInt Primary Key in MSSQL table linked in Access

• by James Travis

• SQL Saturday

• Reply

No sorry, it is a support problem in Access.

2004-03-21

RE: How to ensure order is kept in import from csv

• by James Travis

• SQL Saturday

• Reply

Yes the order should be maintained on import from the CSV file thru DTS unless your table has a CLustered index that would cause a resort. Being however you say you have a IDENTITY column thou it should not.

2004-03-21

RE: Different Counts Returned By 2 Similar SQL Queries

• by maraclec

• SQL in the City

• Reply

Hello,  The reason for the difference is that first one is looking for -- 'smith' -- and the second one is looking for -- smith -- .  The value that you put into the table is -- smith -- and the value that is in the variable is -- 'smith' --.  The first query uses […]

2004-03-19

RE: Primary Key and Idenity check apply to subscriber db for disaster recovery

• by Danette-Mondou

• SQL Saturday

• Reply

I believe the true answer to this question is that you cannot make a simple script to be applied to the subscriber.  Here is another response that I got off the Miscrosoft Newsgroup website.  So far I like this one the best which is very similar to fhanlon response #6 of this thread.Here is the response […]

2004-03-19

RE: WHERE Clause with OR operator: are both statements execd?

• by James Travis

• SQL Saturday

• Reply

It should only evaluate to the first true condition in an OR chain.

2004-03-19

RE: MOM for SQL monitoring

• by James Travis

• SQL Saturday

• Reply

MOM worked well for us but did have a few issues with network traffic on it which was solved by adjusting some of the things it monitored. Ultimately though we dropped it because we needed the box it was on for another project, but all in all it did well.

2004-03-19