Viewing 15 posts - 31 through 45 (of 55 total)
sestell1 (10/15/2013)
Making your user a member of db_datareader will grant the user read access to the entire database.
That's what I thought would happen, but it didn't. The user account...
October 15, 2013 at 12:21 pm
KTD (10/9/2013)
It sounds like you could put this DB into Bulk Logged and save a great deal of logging IO.
We're in Simple Recovery Model.
October 10, 2013 at 5:34 am
KTD (10/9/2013)
October 9, 2013 at 2:06 pm
Kurt W. Zimmerman (10/9/2013)
4) System, Data, Logs & TempDB should be on their separate LUNs.
With sincere apologies the thread hijacking... I'm trying my best to gain insight...
October 9, 2013 at 11:40 am
Kurt W. Zimmerman (10/4/2013)
Things I look at are:1) Are the Data, Logs & TEMPDB on RAID 1/0? or 5? and on separate LUNs?
Which are you looking for? RAID 10...
October 9, 2013 at 6:06 am
sqlsurfing (10/8/2013)
I was curious for the SQLIO test was the test on random and sequential read/writes? Were they all same values or different in SQL IO?
8 threads writing for 120...
October 8, 2013 at 4:34 am
Steve Jones - SSC Editor (10/7/2013)
There are testing utilities, like SQLIO to measure raw performance.
With fourteen 15k RPM SAS drives in a RAID 10 array, at a generous 200 IOP...
October 7, 2013 at 7:23 pm
Steve Jones - SSC Editor (10/7/2013)
You'd have to test it for your workloads. It might, or might not matter.
Kind of hard to test it. I'm building a new server...
October 7, 2013 at 1:18 pm
Thanks - backups will be saved to a file share on a NAS.
My question is whether there is a performance gain that might be realized by separating the physical disks...
October 7, 2013 at 11:14 am
Maximum server memory = 13500 MB.
Other memory options
Index creation memory = 0 (dynamic memory)
Maximum memory per query - 1024 KB
August 27, 2013 at 6:05 am
Sean,
That's exactly what I needed - thanks!
July 29, 2013 at 8:25 am
Jan Van der Eecken (6/19/2013)
Just OUTER JOIN tableA, tableB and tableC on id_number.
Point of clarification -- sometimes data will be entered in TableA and not in TableB or TableC. ...
June 20, 2013 at 5:20 am
Thank you.
Will the change require a restart of the SQL Server service?
April 29, 2013 at 7:31 am
I am referring to using separate LUNs (on different SAN RAID groups, that is, different physical disk arrays) for DATA and LOG files, with a simple recovery model.
Is that recommended,...
April 16, 2013 at 3:19 pm
Viewing 15 posts - 31 through 45 (of 55 total)