a slightly easier way could be using row_number over order by

for example, to get the first item in sysobjects by type (first table, first proc etc)

select x.* from (

select name,...

Number isn't a data type

use decimal and specify the precision and scale

https://docs.microsoft.com/en-us/sql/t-sql/data-types/data-types-transact-sql?view=sql-server-2017

are you using a fully qualified UNC path? such as

\\server\folder1\file1

or a local path

H:\file1

I've had issues with local paths and now everything is UNC for me

if your scaled out DB has just replicated a delete without a where clause then you are just as stuffed as if the scaled out cluster went...

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

sorry, that proc is huge and references views which have functions etc...

that was the first thing I tried

In my place of work we have "internal customers"

our departments cross charge each other (it makes no sense to me) but our marketing team have a budget that they can...

I don't think that you can get a 1 minute diagnosis on a newish system.

Even the best of us get surprised by  the way things manage to go wrong...

I love SQL compare - but we need the SDK back...I used it in 1 company to compare our release code to 200 servers (casino memberships) to ensure all code...

Thanks Grant - that was my suspicion

is there any way to get this parameterised without shouting at 40 developers and the entire team at Microsoft that built MS Access?

Thanks for the article. 1 Trillion rows caught my attention. How would you compare and RDBMS row to a NoSQL row. Can I consider a NoSQL "row" as a...

thanks for the correction … my bad

interesting - and majorly worrying

quite a few are based around facial recognition.

some of what we do is eye tracking for adverts (for example percentage of people who look up at...

I'd avoid the trigger

just based on the fact that it will fire (even if it does nothing) on every modification action to the data on that table  (depending on how...

I can give a really good example of why "well written" unit tests are valuable.... it's not about new code

imagine you have a table of people and there is a...