RE: Pagingfile placement
How (and where) can it be set at the os level that the pagefile is not recreated each time the server restart?ThanksCarl
2004-01-20
2 reads
Analysis Services (SSAS)
RE: Newbie question - Views & delete
Views based on a single table are no problem.I've not ever attempted to even try to delete from view where the view was comprised of 2 or more tables.Be intrested to see what others post.
2004-01-16
RE: email validation
Sort of a Moment 22 then? How would you know if the address is valid without trying to send it? Only the mailserver knows if it can send the mail or not. However, if you wonder about how to validate a string to be conformant to a valid address (ie that the 'format' is right), […]
2004-01-14
RE: Using Apostrophe () in data
You can replace the apostrophe with two apostrophes in the front end, but the better solution is to use a parameterized command object.
2004-01-13
RE: registering a remote database
Kenneth, You are correct, but surely SQLBill is on the right track here - just because you can ping the server doesn't mean that TCP 1433 (or whatever non-default port may be in use) is open for SQL Server connections. I thought we should clarify that so that MegHardy would know that they should follow-up […]
2004-01-08
RE: Deletign a log file: Urgent
I use these 2 statements as two different steps in a job to back up the log and then truncate it. Works well.Step 1BACKUP LOG [MyDB] TO DISK= 'D:\Backup\MySqlServer\MyDB\MyDbLog.dat' WITH NOINIT , RETAINDAYS=2, NOUNLOAD , NAME = N'MyDB Translog Backup', NOSKIP , STATS = 10, NOFORMATStep 2USE master BACKUP LOG MyDB WITH NO_LOG GO USE MyDB […]
2004-01-07
1 reads
RE: Beta Test New Forums
Processing aborted when updating my personal info. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/ www.dkranch.net
2003-12-29
RE: Structuring SQL to retrieve data from child recs
weissa, Can you answer jxflagg Last question? I have no clue about what are your presentation requeriments and That makes it harder for me so I am guessing now: Suppose you have TableChild (ChildID int, ParentID int , Property varchar (100)) You Could Do: Declare @strAllChilds varchar(4000) Declare @MasterRecordID int SET @MasterRecordID = X SELECT […]
2003-12-24
RE: Slow Response on Clustered Server
quote: App is too slow starting the connections up on the fly. These take up resources. Ahh. So you're saying the reason for the poor database response may be the hogging of SQL resources by Lawson, and I'm just witnessing the symptoms of it even in Query Analyzer.
2003-12-18
1 reads
2003-12-17
2 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers