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, 7 months ago by MVDBA (Mike Vessey).

fi you did something like this

select * from mytable with (tablockx)

then you have granted an exclusive lock against the entire table and no writer should get access

you can also test...

Great article, and i'm glad you enjoy contributing to the site, it has certainly helped myself as well

one of my previous employers put every new employee through a "consultancy and...

I know this sounds obvious, but have you tried putting it into an SSIS package? (for the love of god please bring back DTS)

you schedule that in SQL agent and...

back in the day of mirroring, if a transaction couldn't be committed to the standby then it would lock the primary (unless you had enterprise edition and hi performance mode)

this...