Viewing 15 posts - 36,811 through 36,825 (of 39,720 total)
In sysindexes, a row will be added for the table with indid > 0. A 1 is clustered, other numbers are nonclustered.
Steve Jones
November 25, 2002 at 9:36 am
Very very true. Be sure that if you move servers, the target server issue may crop up as well.
See my kill that target article for details.
Steve Jones
November 21, 2002 at 1:51 pm
Shouldn't hurt to reinstall SP3 and might help.
Steve Jones
November 21, 2002 at 1:49 pm
connect to master, not the db to be restored.
Steve Jones
November 20, 2002 at 6:48 pm
Look at Brian's book. Basically, you need to be monitoring and baselining over time. Brian has ways to make this easy.
Steve Jones
November 20, 2002 at 6:41 pm
Internet - Use an anon user with Integrated security. Trap the user/pwds in the app and store them (encrypted pwd) in a table.
Intranet - Using Windows auth. Works well.
Steve Jones
November 19, 2002 at 2:48 pm
I think this will still work on 7.0. I reviewed a security book recently (not yet published) and the author had an interesting way to do this. Under NDA, so...
November 19, 2002 at 2:46 pm
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...
November 19, 2002 at 2:44 pm
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...
November 19, 2002 at 1:37 pm
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...
November 19, 2002 at 1:30 pm
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...
November 19, 2002 at 1:27 pm
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
November 19, 2002 at 9:48 am
Not sure what you mean? Is one of the SQL Servers under professional? What versions of SQL?
Steve Jones
November 19, 2002 at 9:43 am
Viewing 15 posts - 36,811 through 36,825 (of 39,720 total)