Hi,

Just as an idea. Is it suitable to you to execute a separate scripts from t-sql or from your code. Then you'll not have those issues with the apostrophes.

Regards,

IgorMi

Hi,

There is page_count column from sys.dm_db_index_physical_stats() dynamic view which tells you how many pages the index has. You can use it for example to rebuild the indexes having more than...

Hi,

Use this code for e.g

select ss.name [schema], object_name(ddips.object_id) table_name, si.name index_name,

ddips.page_count * 8 [Size KB], ddips.page_count * 8/1024.0 [Size MB]

from sys.dm_db_index_physical_stats(db_id(), null, null, null, 'SAMPLED') ddips

join sys.indexes si on ddips.index_id...

Nice question

Thanks

Hi

This is the output from your query:

namepage_countindex_depth

IBPCorrespondingContractNumber798454

IBPCorrespondingContractNumber2795023

IBPCorrespondingContractNumber3795023

The clustered index on BpId:

namepage_countindex_depth

IBPContentId5763204

It seems it's not the size, especially for the last two indexes.

Thank you, anyway.

Yes, It should not be unless if your account is one of the orphaned.

Well, try by resetting the password of your Login. Check some other stuff, and inform the...

What does

exec sp_change_users_login @Action='Report'

say?

Take a look on this: http://msdn.microsoft.com/en-us/library/ms174378(v=sql.105).aspx

Regards,

IgorMi

Hi,

It's a typical cycle type deadlock.

Which isolation level do you use?

Regards

IgorMi

Hi,

Is your SQL Login Enabled? (check Properties->Status for Login). Once I had that problem.

Also check the User mappings and other properties for the Login.

Regards,

IgorMi

Hi,

There are some existing recommendations for the tempdb files. These two are most advised:

- If the server has more than 8 cores then start with 8 tempdb files; or

- The...

Hi Jeff,

Another useful article, Thank You!

I repeated your work on my machine and the improvement was between 1.5 and 1.7 times.

Regards,

IgorMi

Got it wrong, because 84% got it wrong too 🙂

BIDS will stay among the folks, as shorter it is as easier to use.

However thank you!

Why error? what is wrong? Everything seems correct except the mirroring will not start because you miss the transaction log backup restored on the srv2.

Hi,

It never happened to someone to have those problems like "will the INCLUDE section satisfy my requirement to create 10,20,50... columns" It usually supports 3-digit or more number of columns.

It...

...and do you want the new column to replicate or not?