RE: inserting last record....
i will change the trigger structure so that i 'treat the data as a set', as u said..am still curious why the trigger is not executing for every record !!!thanx alot for ur help..TNT
2004-02-11
events
RE: new year new number Generating in SQL server
I see you state you already have a coulmn with autonumber in it.How are your inserts done. Direct insert statement, select insert statement, wrapped in Stored Procedure or some other way?
2004-02-11
1 reads
RE: Question of the Day for 10 Feb 2004
1. Google returns no rows for a "TSC test server". 2. The fastest RAID 5, reads and writes faster than the fastest RAID 1. 3. RAID 10 cannot survive multiple drive failures when they occur on opposite sides of the mirror. 4. RAID 5 is THE best solution. 5. RAID 5 is THE solution used by all major hardware vendors. […]
2004-02-10
RE: Question of the Day for 10 Feb 2004
Yes, RAID 10/01/1+0/0+1/SAN/etc. would be nice, but of the choices given ... RAID 5 advocates need to remember that the log needs to do flat-out writes as fast as possible. A log I/O is the single disk I/O event that a user ever has to wait on synchronously, so you basically need to optimize for […]
2004-02-10
1 reads
How can i make auto number from the first day of the year?
How can i make auto number from the first day of the year?How can I make this?From the binging of the year In the date of 01/01/2004 I wont that the number will bee 1-2004 And after. 2-2004 .. 3-2004 ……………………………….. 99-2004 AND until the end of the year of 2004 AND in the beginning […]
2004-02-10
Why cant my query update a linked table?
Why can't my query update a linked table? I have a query in MS Access that has a linked (ODBC) SQL Server table as it's source. To get the results I need the query uses three separate fields for criteria. The query returns the correct data set, however when any data is changed / updated […]
2004-02-06
RE: left outer join...
You have Duplicates OrderIds on your "order_old" table or on your "order1" table HTH
2004-02-06
Question of the Day for 05 Feb 2004
Comments posted to this topic are about the Question of the Day for 05 Feb 2004 posted at http://qa.sqlservercentral.com/testcenter/qod.asp?QuestionID=175.
2004-02-04
2004-02-04
RE: Checklist for DB design needed
As for the checklist, db design practice:http://www.microsoft.com/downloads/details.aspx?FamilyId=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=enAs for the max rowsize:http://qa.sqlservercentral.com/columnists/sjones/pagesize.aspAs for max. no of columns:Take a look at BOL for 'Maximum capacity specificationsAs for performance monitoring:Sorry, there you need to wait for other members. I'm not too familiar with it.HTH
2004-02-04
1 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