RE: Sorting by Date
Thank you! I think these ideas will solve the problem! I KNEW it was something right in front of my face!
2005-04-21
QUOTENAME()
Updating a table with only one occurence of row from another table
I need to perform weekly updates of Table B. The data is derived from a table linked to an excel spreadsheet A. There may be several rows in this table which contain duplicated id's. What I need to do is take just one occurrence of the id but sum the line amount as follows:-A BUnique ID Line […]
2005-04-21
1 reads
RE: How to determine DBCC Checkdb , execution time?
It depends on your server hardware. Just kidding , but hardware an RAM definitely has an impact. Dont' know if this helps you or not, but I have a 16.5 Gig user DB on a 2 X 2.4 gig CPU server with 2 gigs of RAM and DBCC CheckDB's complete on this in about 7 1/2 […]
2005-04-20
2005-04-20
RE: Problem with Variables. SQL Server 2000
Personally, I do prefer (and use) the 'single-update' method to increment and return the next countervalue in one go. It makes it unnecessary to wrap in explicit transactions and such. It's physically impossible for the server to return the same counter to more than one caller.update counterTable set @nextid = nextId = nextId + 1 […]
2005-04-20
RE: Removing old DBA logins
Yes, you can delete NT Authentication logins that have been deleted from the domain, because even if they were recreated in the domain, they would have different spid and so would not be recognized by SQL server anyway.
2003-06-05
RE: SQL occupied 90% usage and 99% outgoing traffic
It sure sounds like Slammer, but you have SP3 already applied. Have you looked at the traffic with an analyzer to see where the data is going? That much traffic is extreme for SQL to be putting out.
2003-06-05
RE: SQL Server Mag User Study
I just shot myself in the foot. I gave bogus info there! Dho! Maybe I change it. Wonder if they will send it international? Cheers, Crispin
2003-06-04
1 reads
RE: SQL Perf Counters Lost
I have the same probelm on 3 SQL 2000 servers each running 3 instances of SQL. I have a call with Micrososft for this one. 3 weeks on we still havnt resolved the problem. Last call was to rebuild all servers.....
2003-06-02
1 reads
Blogs
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...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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