Cool2018

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 20 total)

RE: huge free spaces in data file can make query slower?

Jeff Moden - Saturday, November 3, 2018 11:41 AM
Cool2018 - Saturday, November 3, 2018 10:22 AM

November 4, 2018 at 9:27 pm

#2012360
RE: huge free spaces in data file can make query slower?

Jeff Moden - Friday, November 2, 2018 9:43 PM
Ah... Just noticed that you're using 2014. The VLF algorithm changed there. See the...

November 3, 2018 at 10:25 am

#2012309
RE: huge free spaces in data file can make query slower?

Jeff Moden - Friday, November 2, 2018 9:32 PM
I'm not sure why you have so much free space for the NDF files. ...

November 3, 2018 at 10:22 am

#2012308
RE: huge free spaces in data file can make query slower?

Jeff Moden - Friday, November 2, 2018 3:29 PM
Cool2018 - Friday, November 2, 2018 9:35 AM

November 2, 2018 at 7:49 pm

#2012300
RE: huge free spaces in data file can make query slower?

Jeff Moden - Friday, November 2, 2018 7:32 AM
For 1, usually you don't need a commit unliess you've made the mistake...

November 2, 2018 at 9:35 am

#2012213
RE: huge free spaces in data file can make query slower?

Grant Fritchey - Friday, November 2, 2018 4:11 AM
1) The pages are still 8k, no matter what. Nothing about database growth...

November 2, 2018 at 5:07 am

#2012164
RE: huge free spaces in data file can make query slower?

andycadley - Thursday, November 1, 2018 10:12 PM
Cool2018 - Thursday, November 1, 2018 8:39 PM

November 2, 2018 at 12:58 am

#2012144
RE: huge free spaces in data file can make query slower?

andycadley - Thursday, November 1, 2018 10:03 PM
Cool2018 - Thursday, November 1, 2018 8:17 PM

November 2, 2018 at 12:54 am

#2012143
RE: huge free spaces in data file can make query slower?

Jeff Moden - Thursday, November 1, 2018 5:12 PM
There IS a form of freespace that WILL cause your code to run slower...

November 1, 2018 at 8:39 pm

#2012138
RE: huge free spaces in data file can make query slower?

Jeffrey Williams 3188 - Thursday, November 1, 2018 4:08 PM
Cool2018 - Thursday, November 1, 2018 9:18 AM

November 1, 2018 at 8:23 pm

#2012136
RE: huge free spaces in data file can make query slower?

andycadley - Thursday, November 1, 2018 1:33 PM
It's worth bearing in mind that the shrinking currently is probably only harming your database....

November 1, 2018 at 8:17 pm

#2012135
RE: huge free spaces in data file can make query slower?

Grant Fritchey - Thursday, November 1, 2018 10:15 AM
1) Yes.
2) Not really. Rebuilding indexes, probably something you'd want to do after data...

November 1, 2018 at 8:10 pm

#2012134
RE: Keeping huge free spaces in data file can make query slower?

Grant Fritchey - Thursday, November 1, 2018 5:21 AM
Please don't cross post questions. It makes the conversation difficult to keep track of.

November 1, 2018 at 9:20 am

#2012062
RE: huge free spaces in data file can make query slower?

Grant Fritchey - Thursday, November 1, 2018 5:15 AM
1) No. It doesn't work like that. The only issue possible is if, let's...

November 1, 2018 at 9:18 am

#2012060
RE: Q related to Clustered columnstored index

Dear Grant,
Thank you so much for your information.
Best Regards,

August 28, 2018 at 2:01 am

#2003547

Viewing 15 posts - 1 through 15 (of 20 total)