Forum Replies Created
Viewing 15 posts - 36,991 through 37,005 (of 39,903 total)
-
RE: view is not being refreshed !
select * is built at view compile time. You should really specify the columns so you know to add them to the view (with Alter View).
Steve Jones
-
RE: A Temporary Move
Thanks, I'll fix this.
Steve Jones
-
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...
Viewing 15 posts - 36,991 through 37,005 (of 39,903 total)