At least is says „database file“, class 22.

when looking here it is written little bit different, saying @level1type can be „logical file name“.

thanks for the answer, and ok, when not...

• This reply was modified 4 years, 6 months ago by  WolfgangE.

Thank you for the reply 🙂

I did not get the name of the current stoplist yet. This statement does not give a result:

select * from sys.fulltext_stoplists

Yes, as...

Edit:

What drives me kind of crazy is the following out of books online:

Inserts or deletes a stop word in the default full-text stoplist of the current database.

Wouldn't the default stoplist...

Hello there,

this is a nice article, and really sums up some important points.

I'd like to add 2 things 🙂

1)

As for formatting, I personally think putting the line break characters at...

Hello Scott, thank you for the answer.

That makes sense and the whole thing more clear. I thought non repeteable reads only occur when having at least 2 statements within 1...

Hello 1974lg,

yes, quite a while since that post....
In  the environment I was working on when writing this post I did not had any troubles with partitioning....

hello there,

an addition to the "drop and create" question:in newer SQLServer versions finally the CREATE OR ALTER syntax was introduced. I'm not sure if in SQL 2014, but...

Hello there,

this is a nice article, showing the danger of this kind of SQL code.
Actually there are many people not knowing the detailled behaviour of this code,...

hello Zafar,
try to just recreate the index of the primary key, using the option "with ( drop_existing = on )". Use the new filegroup or partition sheme as target...

Hello there,
actually I did not really understand your szenario, and which server ist publisher, wich is subscriber....

In general:
If you new server is a publisher and/or distributor,...

Hello Zososql,

your example is really hard to understand.
It's good that you provide DDL and sample code. But please post DDL that works, and SQL-Statements that work too....

hi,

thank you for the answer.

I know I could optimize the index, but that's not the point. I'd like to understand why optimizer is estimating the way it does 🙂

hello Peter, hi all,

yes, this kind of coloring is really great.

Still take care!!!

Unfortunately this is not 100% reliable. I use these colors for about three years now, in SSMS 2008...

hmm... sorry, no idea...

hi there,

meanwhile I got this error too in some situations.

The definition of object has changed since it was compiled

It occurs when you run a ALTER PROCEDURE command while the altered...