Viewing 15 posts - 45,991 through 46,005 (of 49,552 total)
Jeff Moden (7/2/2008)
We can do that! I'll actually be at PASS this year! Looking forward to meeting you and many of the "old timers"...
Excellent. We should organise a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2008 at 12:58 pm
Jeff Moden (7/2/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2008 at 12:45 pm
OleHank (7/2/2008)
DECLARE @truthTable char(42)
SET @truthTable = '111111012345201333330143444015345501234560'
SET @retVal = CAST( SUBSTRING( @truthTable,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2008 at 12:37 pm
Jeff Moden (7/2/2008)
Oh my... wow... WOW! HOLY MACKERAL! :w00t::blush:
Congrats Jeff. When you get down from cloud nine, let us know. Don't rush though, this doesn't happen every day. :w00t:...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2008 at 12:26 pm
Gaby Abed (7/2/2008)
However when I change @sqlstring to the following: select @sqlstring = N'select @db..sysindexes'
you need to concatenate the value of the variable into the string. This should more-or-less...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2008 at 7:38 am
Try downloading process explorer and see if you can identify what is using that file. If you can find out and you can remove that open file handle, you should...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2008 at 7:27 am
Ah. Now we get somewhere.
Do you have an anitvirus that may be (or may have been) scanning the file? Do you perhaps have a file backup that may be (or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2008 at 7:19 am
Are there any errors in the SQL error log?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2008 at 7:07 am
Is the log file where SQL expects it to be? That error indicates that the log fle couldn't be read.
Have a look in the SQL error log, see if you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2008 at 6:44 am
Try using the query execution plan to see if the index is used o not.
Without more info on table structure, index structure and query, I can't even begin to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2008 at 6:28 am
Michael Earl (7/2/2008)
True, but what are the odds we're both off our meds on the same day?
Good point.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2008 at 6:21 am
Or we're both delusional, which is at least possible... 😀 😉
Considering I'm still up on cloud 9, it's not so unlikely for me. :w00t: :w00t: :hehe:
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2008 at 6:12 am
Yes. A full backup contains all schema objects and data.
How does a query fail because of a missing trigger?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2008 at 6:07 am
Did you check to see if the index you created was useful for the query?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2008 at 6:04 am
You need to find the application that is vulnerable to injection (you can use profiler to see the commands coming to the database)
There isn't a quick silver bullet on this....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2008 at 6:01 am
Viewing 15 posts - 45,991 through 46,005 (of 49,552 total)