Forum Replies Created
Viewing 15 posts - 36,871 through 36,885 (of 39,771 total)
-
RE: Aggregate in the set list of an UPDATE statement
Use a derived table
update ss
set
leadsTotal = stateOrProvince
, revenueGross = Revenuegross
, leadDistributed = leaddistributed
, leadCost =leadCost
from (
select leadsTotal = count(stateOrProvince)
, revenueGross = sum(leadRevenue)
, leadDistributed = sum(leadCount)
, leadCost =sum(leadRate)
, stateorprivince
from
#leadDistributionSummary
group...
-
RE: best practice disk arrays
We're looking at SANS here, so it will be interesting to see how it performs.
Our standard for the data center:
1. RAID 1 - OS + SQL OS + pagefile
2. RAID...
-
RE: Recommendations for db roles for vb developers
how about denyreader, denywriter?
Seriously. In development, I'd give them some role (Developers?) that I created and assign the rights as needed. I keep the rights with the...
-
RE: Deny Access to SA
You can deny access to a table for dbo, which is the user for sa in a database. However, not sure dbo can own the table, so you might need...
-
RE: Winodws NT Processor
SQL is more advanced than NT. 64 bit ready (different version), but the support is
there. SQL works with memory and processors, needs OS support.
Steve Jones
-
RE: DTS
Not sure what you mean? Is one of the SQL Servers under professional? What versions of SQL?
Steve Jones
-
RE: A job failed that is scheduled to run every day
What is the source? Possible a network error? Or unable to gain an exclusive lock?
Steve Jones
-
RE: xp_sendmail with Triggers - arrgh !!!!
no lock shouldn't matter.
I wouldn't do this. Instead, I'd use a process that runs every minute or so and looks for changes and sends mail. Less likely to cause...
-
RE: Money Datatype
Use multiplication (*1000) and then division to find things = 00.
Alternatively, change the datatype to numeric and limit to 2 decimals.
Or add a trigger to round to 2 decimals.
Steve Jones
-
RE: Dropping database by issuing a cancel restore
I suspect the db creation is part of a transaction. IS this restoring any database or only a new database?
Steve Jones
-
RE: Enterprise Manager error when designing tables
Bad install. I'd reinstall the tools.
Steve Jones
-
RE: Move Your Master
Could be performance, mostly for tempdb. Personally, it's a standards thing. We move all the data to a drive and logs to another. May further separate out, but we have...
-
RE: How to track updates/deletes/selects on DB tables
Profiler is your only shot
Steve Jones
-
RE: Creating Your Dream Project
My 2 cents. This is pretty good, though be sure you can deliver what you promise. If you don't you sully your reputation rather than enhance it (for that job).
However,...
-
RE: locking
How long are the locks held? I wouldn't expect most of these to run long.
Steve Jones
Viewing 15 posts - 36,871 through 36,885 (of 39,771 total)