Viewing 15 posts - 1 through 15 (of 859 total)
For my company it is cost. Sinking 7k a core for enterprise means its a long term expense that will be there for 4-5 years at least. We...
September 18, 2014 at 9:54 pm
GilaMonster (10/17/2013)
CapnHector (10/16/2013)
EDIT: After looking at it some more it really looks like this IAM page is not tracking any allocated space since there are no single page allocations...
October 18, 2013 at 1:33 pm
GilaMonster (10/17/2013)
CapnHector (10/16/2013)
October 17, 2013 at 9:17 am
Not sure it matters but i noticed the following mismatch, NVARCHAR(MAX) for images and VARCHAR(12) for current_image
declare @images nvarchar(max)
set @images = ''''
declare @current_image varchar(12)
The other issue i see is...
October 17, 2013 at 9:09 am
Well after much research and digging deeper into the storage internals than I ever have before, I am reasonably sure this IAM page does not track any data pages which...
October 17, 2013 at 9:03 am
Jeff Moden (9/20/2013)
hisakimatama (9/20/2013)
September 20, 2013 at 1:40 pm
another option i have seen is that if you have a job that is run once a minute and its not triggered by any thing (DB stats logging in my...
March 20, 2013 at 2:03 pm
opc.three (3/19/2013)
I have four temp dbs (100 meg and three 200 meg--which I want to set all to 100)...
March 20, 2013 at 2:00 pm
sestell1 (3/18/2013)
akberali67 (3/18/2013)
I have a query window with a lot of code but I do not want to run it entirely in error, is there something I can place in...
March 18, 2013 at 2:21 pm
not sure if it would increase the performance or not but another option is a filtered index (possibly one for each year?). Would deffiniatly need to test in DEV...
March 14, 2013 at 1:29 pm
sqlfriends (3/14/2013)
For my case, do you think if I use above grant to schema permissions, it is better to create a customized role first?Thanks
My preferred method is to use Roles...
March 14, 2013 at 1:17 pm
sqlfriends (3/14/2013)
Chris Harshman (3/13/2013)
sqlfriends (3/13/2013)
...They may need to read and write and also execute stored procedures in the databases...
Typically when it comes to security you want to grant the least...
March 14, 2013 at 11:35 am
dan-572483 (3/12/2013)
sqlfriends (3/12/2013)
dan-572483 (3/12/2013)
Good general rule: Jobs that need to run once but NOT more than once should not be scheduled between 1 & 3am on Sunday mornings.
But I don't...
March 14, 2013 at 11:16 am
Jeff Moden (2/27/2013)
CapnHector (2/27/2013)
March 4, 2013 at 3:07 pm
insanityflyff (2/27/2013)
CapnHector (2/27/2013)
February 27, 2013 at 3:46 pm
Viewing 15 posts - 1 through 15 (of 859 total)