RE: Temp Tables or Something Else ??
Thanks, Phil, for your response and suggestion.If there are different ways to do this, please also post it here otherwise, I will use the way I was already thinking about and which Phil also suggested.
2005-02-15
u-sql
SQL Server DBA in Richmond, VA -- Contract to Hire
Hi all,My client is looking to hire a skilled SQL Server DBA and give them the opportunity to learn PEOPLESOFT and be the DBA for that as well!!!!!Excellent opportunity to learn PS and show your SQL Server talent.Salary is 60-65K. This is a contract to hire position and you must be willing to relocate to […]
2005-02-15
1 reads
RE: Creating a Job from a Trigger - Problem
Specify the account 'sa' when you create the job step that runs the CMD job. From BOL:[@database_user_name =] 'user'Is the name of the user account to use when executing a TSQL step. user is sysname, with a default of NULL. When user is NULL, the step runs in the job owner's user context on database.
2005-02-11
RE: How Can I Select All But One Record?
Assuming that the column EnRID is a unique row id, try this:UPDATE Enrollment SET ISMID = NULL WHERE Enrid IN (SELECT MIN(E.ENRID) FROM ENROLLMENT E INNER JOIN (SELECT ismid, Mydate FROM enrollment WHERE ismid IS NOT NULL AND active = 1 GROUP BY ismid, Mydate HAVING COUNT(*) > 1) […]
2005-02-08
Memory Performance Counters
I am currently running some performance stats against our SQL server. I have been looking at CPU, Memory and Disk IO but am confused by the counter Memory - Page Faults/sec, what would an average be for this counter for reasonable performance. Whilst i'm on the topic aswell, what is a good figure for Memory […]
2005-01-25
1 reads
RE: Reporting Services Programming Guideline
I like these books: Microsoft Reporting Services in Action by Teo Lachev Hitchhiker's Guide to SQL Server 2000 Reporting Services by Blackburn/Vaughn
2005-01-25
DB Design question
Hi everybody I would appreciate some help with the following design problem: The application is about documents with paragraphs. The documents are in a table, and each document consists of various paragraphs, which are also kept in a table. If a document is created using paragraphs 1, 13, 27 & 54, it is easy to […]
2005-01-25
RE: Query Date Range Against Date Range
You have staff who are contracted (with date ranges) You have jobs (with date ranges) and you want see if any staff can fulfill any jobsQuestions Where is the relationship between staff and jobs? (or is that the contracted date range) How do you determine whether the member of staff is qualified to do the […]
2005-01-20
RE: SP for CDO Bulk Mail Fails - Help!!
Unfortunately the mail body is an HTML page so it appears xp_sendmail won't work. As far as I can tell from BOL xp_sendmail only sends text messages...I'll look at CDOLive. Thanks.
2005-01-06
RE: SQL Profiler
Hi, have had similar problems and used the option where database name 'not like' as opposed to 'like' and listed all the others. Depends how many you have I guess...long winded but worked.
2005-01-06
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