MVDBA (Mike Vessey)

Forum Replies Created

Viewing 15 posts - 421 through 435 (of 1,993 total)

Reply To: Are the posted questions getting worse?

Thom A
i agree, but there is also one point on the quality of posted questions... language barrier. English is not my first language (heck it's my 3rd language)
A lot of...
MVDBA

January 30, 2020 at 9:56 am

#3721528
Reply To: Are the posted questions getting worse?

Grant Fritchey wrote:
Jeff Moden wrote:
To add to what Grant has stated, I agree that "new" voices are a bonus on any forum but I have seen some "new" people come in with...
MVDBA

January 30, 2020 at 9:04 am

#3721509
Reply To: Surrender, Just a Little

Grant Fritchey wrote:
I would like to defend myself, just a little. I didn't say surrender completely. I said, surrender, just a little. A lot of our peers see our rants about...
MVDBA

January 30, 2020 at 9:00 am

#3721506
Reply To: Are the posted questions getting worse?

wrote:
You learn so much more when you start to teach others.
could not agree more - most of my learning came from working as a consultant and seeing how...
MVDBA

January 30, 2020 at 8:50 am

#3721501
Reply To: shrinkdb issue

surely if I moved all of the data to a NEW file in the filegroup then none of those conditions can occur
besides, I can see the data in the tables...
MVDBA

January 30, 2020 at 8:37 am

#3721497
Reply To: SSMS 18.4 (SQL 2014) Activity Monitor Always Blank

Sue_H wrote:
Just to clarify - I didn't mean to point to anyone's blog in particular - KendraLittle and ScaryDBA are a couple of the best SQL server blogs out there....
MVDBA

January 30, 2020 at 8:33 am

#3721496
Reply To: DB architecture — Which database is best for single key search

this sounds very much like a scenario for A KV NoSQL database - maybe mongoDB would serve you well.
MVDBA

January 29, 2020 at 5:33 pm

#3721310
Reply To: shrinkdb issue

first thing I did - then a checkpoint and dbcc shrinkfile(2,1) - it's not the log - the log is tiny. it's a .ndf file that is misreporting it's free...
MVDBA

January 29, 2020 at 5:29 pm

#3721309
Reply To: SSMS 18.4 (SQL 2014) Activity Monitor Always Blank

Sue_H wrote:
I rarely have ever ranted up here so I'll stop now. But it is one of my "rants" kind of thing.
It's not a rant - it's an opinion,...
MVDBA

January 29, 2020 at 5:12 pm

#3721306
Reply To: SSMS 18.4 (SQL 2014) Activity Monitor Always Blank
Mr. Brian Gale wrote:
Just to throw my 2 cents in this, I have a quick and dirty little script template that I did up ages back to help with sp_who2:
```
MVDBA
```
January 29, 2020 at 4:35 pm

#3721285

Reply To: Why A Query May be Faster the Second Time it Runs

nicksamuel wrote:

Just a question about flushing temp tables.

From what I have experienced, if a routine creates one or more temp tables on the first run, these are just used again...

MVDBA

January 29, 2020 at 4:18 pm

#3721277

Reply To: Are the posted questions getting worse?

Just a thought,

every post I've replied to in the last few weeks has had updates and new info from pretty much the same bunch of people on here.

Grant, Jeff,KTFlash, Jonathan...

MVDBA

January 29, 2020 at 3:20 pm

#3721238

Reply To: Why A Query May be Faster the Second Time it Runs

erb2000 wrote:

How can I force Sql Server to not use the cache or other optimizations so that the same query always takes the same amount of time? When trying to...

MVDBA

January 29, 2020 at 2:07 pm

#3721220

Reply To: View runs slower

Grant Fritchey wrote:

Also, thinking on this, are you saying that the query and the view are the same, but the view is slower? Or are you saying that you wrote a...

MVDBA

January 29, 2020 at 1:58 pm

#3721210

Reply To: Why A Query May be Faster the Second Time it Runs

julian.fletcher wrote:

Declare @DBID Int Set @DBID = DB_ID ()
Checkpoint
DBCC DROPCLEANBUFFERS WITH NO_INFOMSGS
DBCC FLUSHPROCINDB (@DBID) WITH NO_INFOMSGS

That will clear execution plans and data from memory, which would be...

MVDBA

January 29, 2020 at 1:55 pm

#3721208

Viewing 15 posts - 421 through 435 (of 1,993 total)