are you doing this for a job interview/school exam?

PAGEIOLATCH_SH

Occurs when a task is waiting on a latch for a buffer that is in an I/O request. The latch request is in Shared mode. Long waits may indicate problems...

this is going to be painfull

my advice would be to do it manually

BUT if you query msdb.dbo.sysjobsteps there is a column called "command".. you could try and scrape proc and...

write it up as an article for the site, it's quite an interesting find. I'm sure steve would love it

Hi thomas

we're restoring to a dev server, so filegroup restores would be a nightmare.

i've found the best way is redgate source control and GIT with sql compare if needed

is it a heap? (does it have a clustered index)

if you process things nightly and delete data then the space can remain allocated but the data content is a lot...

and yes you can assign and index to player name - but get an execution plan first and see what it really needs

create index IX_scores on highscores(playername) would be approximately...

Thank You.

Can i define player_name as an index?

How do i  add highscores to the table using pr_PutHighScoreList(stored procedure)

You can only appear on the high score list once, and only...

to the original poster

it might be wise to google the difference between row_number, rank and dense rank - scdecade was right to point out these options, but you need to...

take the brackets out of the between statement - I put them in by accident

ok - fairly simple,in the article the 2 domains have been told not to trust each other

the workaround should work, but let your network team handle it - as a...

sounds like the service pack might have shut down a sql protocol that you use in your linked servers

can you post the error message?

failing that, drop and re-screate the linked...

We're going through this process at the moment, but the issue isn't purely source control

I have maybe 400 databases to create repositories, clone and link to GIT... i'm about 40...

I use redgate's sql dependency tracker (part of toolbelt)

although you can use the sysdepends table (it's not accurate if you have dynamic sql or objects are built in the wrong...

something like this might work

DECLARE @rnk INT

SELECT @rnk=

rnk FROM (

SELECT ROW_NUMBER() OVER (ORDER BY score) AS rnk,* FROM highscores

) AS X WHERE NAME='Bob'

SELECT *

FROM (

SELECT ROW_NUMBER() OVER (ORDER BY score)...

• This reply was modified 6 years ago by MVDBA (Mike Vessey).