Viewing 15 posts - 36,886 through 36,900 (of 49,552 total)
Any pattern in when it happens? Any entries in the SQL error log or windows event log that coincide with the time it starts?
What OS, how much memory? Do 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
August 21, 2009 at 12:34 pm
If you do get a difference, please blog it. Also, if you do get a difference, try OPTION (RECOMPILE) on the query, see if there's any change. Shouldn't be, recompile...
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
August 21, 2009 at 12:31 pm
Has someone run DBCC FREEPROCCACHE? Restored a database or log? Run an sp_configure changing a setting?
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
August 21, 2009 at 11:33 am
Krasavita (8/21/2009)
I think there is another process on moving system db from one location to another then I was giving here.
Yes, there is.
Are you saying it is the same process...
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
August 21, 2009 at 10:38 am
Krasavita (8/21/2009)
1.How to - move the files at OS level?
Are you serious? Do you not know how to move a file using window explorer?
2.Do you have a link how 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
August 21, 2009 at 10:07 am
5AM? That's dedication.
Just a note, my indexing session's mostly a level 200, so don't expect deep technical dives.
I've got 7 that I want to attend (8 if you include the...
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
August 21, 2009 at 10:01 am
David Reed (8/21/2009)
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
August 21, 2009 at 9:48 am
Alvin Ramard (8/21/2009)
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
August 21, 2009 at 9:44 am
As the error says, an indexed view cannot contain a windowing function, ie the row_number column is not allowed. You need to pull a unique column in from one of...
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
August 21, 2009 at 9:31 am
Lynn Pettis (8/21/2009)
Bob Hovious (8/21/2009)
*POUND**POUND*
*POUND*
Ow, my head.... where the @#$%# is that spare keyboard!!! :crazy:
Right there with you. Check out this one.
Oh. My. That's in the 'ten-foot...
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
August 21, 2009 at 9:27 am
I burn my most critical stuff (work docs, SQL scripts, app code, etc) to DVD (Rar'd with password) and give it to my friend. It's not everything, but it means...
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
August 21, 2009 at 9:10 am
RBarryYoung (8/21/2009)
I've already had two major back operations: in 1989 and 1978.
Ow. Not good. Hope you're feeling better soon.
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
August 21, 2009 at 9:05 am
pdchandran (8/21/2009)
We have file replication happening from LUN A to LUN B.
What kind of file replication are you using and has it been certified to work with SQL Server...
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
August 21, 2009 at 8:44 am
Lynn Pettis (8/21/2009)
Grant Fritchey (8/21/2009)
GilaMonster (8/21/2009)
Anyone keen on several pages of cursor-ridden SQL, a badly explained problem, two threads and no data?http://www.sqlservercentral.com/Forums/Topic774014-146-1.aspx
http://www.sqlservercentral.com/Forums/Topic774898-146-1.aspx
Oh, sure. Shoving bamboo shoots under my finger nails...
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
August 21, 2009 at 8:43 am
When an index is created queries queries can use it immediately.
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
August 21, 2009 at 8:02 am
Viewing 15 posts - 36,886 through 36,900 (of 49,552 total)