Forum Replies Created
Viewing 15 posts - 36,811 through 36,825 (of 39,720 total)
-
RE: How to determine if a table has indices
In sysindexes, a row will be added for the table with indid > 0. A 1 is clustered, other numbers are nonclustered.
Steve Jones
-
RE: Moving MSDB
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
-
RE: Renaming the server
Shouldn't hurt to reinstall SP3 and might help.
Steve Jones
-
RE: Restore fails because no exclusive access
connect to master, not the db to be restored.
Steve Jones
-
RE: examples of large databases
Got one at 800GB
Steve Jones
-
RE: examples of large databases
Got one at 800GB
Steve Jones
-
RE: Recommendation on daily sql server monitoring
Look at Brian's book. Basically, you need to be monitoring and baselining over time. Brian has ways to make this easy.
Steve Jones
-
RE: IIS access and Windows Authentication
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
-
RE: Deny Access to SA
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...
-
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
Viewing 15 posts - 36,811 through 36,825 (of 39,720 total)