Viewing 15 posts - 1 through 15 (of 167 total)
Thanks Pam that is the exact code I was looking for.
Great I can get it running to save DMV index recommendations. At the moment most of my tables have no...
June 20, 2020 at 5:43 am
I don't know if you noticed but I had to move the DB from a server to an SQL Express DB on my laptop.
The laptop wont be running 24/7...
June 18, 2020 at 6:36 pm
Thanks,I am pretty sure I got the code off a Microsoft blog years back when DMVS just came out (2005 or was it 2008? Cannot remember)Whether they...
June 18, 2020 at 6:27 pm
As I said in the 1st post I don't automatically implement every recommendation. The DB was designed to just keep DMV data from missing index data over time as when...
June 18, 2020 at 3:16 pm
Well I don't want to look through months of sql or event logs because I have no idea when the problem started and have no way of narrowing it down,...
April 2, 2020 at 3:19 am
Yes, I am always willing to blame a Windows Update for anything. Too many times I have had issues with my laptop and a restore to a point before the...
March 27, 2020 at 4:51 pm
Hi thanks for your response.
I did not get any problems with the backup / restore, I simply SFTP'd the backup from a dedicated server to my local PC and then...
March 25, 2020 at 9:28 pm
Thanks Jacob for the explanation. I have a book I am reading on the history of gambling and how probability is worked out, I just got thrown by the trial...
March 25, 2020 at 2:03 pm
Yes, if I had more than one runner odds on, or so many runners that the probability was over 100% then the problem occurs.
However this is the standard Dutching formula...
March 25, 2020 at 1:27 am
I like it, that query is so SQL 2000, it was and did use old system tables but it still worked with a change to make nvarchar(max) appear rather than...
March 19, 2020 at 12:46 pm
I know overlapping indexes are an issue but one a production system having a permanent DB which stores the missing index DMVs so you don't lose recommendations between server/service shut...
March 18, 2020 at 8:38 pm
Hi, thanks for the replies.
I did try that 3 line SQL code, to set into Single User Mode and then change the DB collation before putting it back to multi...
March 18, 2020 at 3:19 pm
Yes the ASP side is very tricky - not many ASP Classic coders left to ask!
August 9, 2016 at 11:32 am
Well done that fixed that results page but I don't understand why as I just checked all the tables in the SELECT statement and the ONLY one with a column...
August 9, 2016 at 11:05 am
I know they shouldn't that's why I am so confused to what is going on. I will try and insert some screen captures so you can see.
If you go here...
August 9, 2016 at 10:40 am