PASS Virtual Chapters

RE: Installing SQL Server and databases

• by Sopheap-Suy

• PASS

• Reply

This is how we do this in our group:SQL Program file can be on C:\ or it's own drive.Data on it's on driveLog on it's own drive.backup on it's own drive.  mom

2004-01-16

1 reads

RE: Text file destination thru Dynamic Properties Task

• by data_czar

• PASS

• Reply

You can set the data source dynamically using the Dynamic Properties task. Typically you would assign the desired connection value to a global variable(s) and then use the Dynamic Properties Task to change the Data Source and/or (depending on the type of db being used) Catalog properties on the connection at run time.

2003-12-24

1 reads

RE: Structuring SQL to retrieve data from child recs

• by noeld

• PASS

• Reply

quote: quote: There is no info as of now!! on how are things implemented ( used) supposed a Master -Detail Application. I have no idea what you just said. You just cut my post in half!!! quote: There is no info as of now!! on how are things implemented ( used) Supposed a Master -Detail […]

2003-12-24

1 reads

RE: Wrong QOD 16-12-2003

• by Greg-Charles

• PASS

• Reply

Once again, the typo (articleid) in the email is corrected (article_id) on the web page. This has happened enough times that I always go to the web page to read the QOD now. I don't even look at it in the email.

2003-12-16

RE: Database Log File full

• by cynosure772003

• PASS

• Reply

set the auto shrink option in the database raghu

2003-09-03

RE: Batch processing

• by NelsonVere

• SQLServerCentral.com

• Reply

EX: If I run Select TOP 5000 and process it How I select the next range of 5000???

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-07-15

RE: SQL in ADO.NET vs Stored Procedure

• by guarddata

• SQLServerCentral.com

• Reply

Another vote for Stored Procedures. There are times when the SQL is dynamic enough to be done "better" from another tier, but when the parameters and output are known and consistent, Procedures are always my choice. My personal preference (I think this is also what you hinted, jpipes) is to keep the source procedure code […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

Log in or register to rate

You rated this post out of 5. Change rating

2003-07-15

1 reads