Viewing 15 posts - 5,161 through 5,175 (of 8,416 total)
If it really concerns you, take a look at Forced Parameterization. Be sure you fully understand the implications before testing it.
Unless you can show that procedure cache bloat is...
March 18, 2010 at 5:13 am
GilaMonster (3/18/2010)
A disabled foreign key is still a foreign key and a table referenced by a fk cannot be truncated.
Unless it is a self-reference 😉
March 18, 2010 at 5:07 am
Menu: DataSource View --> Refresh
Alternatively, there is a small refresh icon at the top left of the design window.
March 18, 2010 at 5:04 am
alx.beneventi (3/17/2010)
select @fUsePattern = 1 to select @fUsePattern = 0
Can anyone tell me if it is...
March 18, 2010 at 4:56 am
rgarrett 82118 (3/17/2010)
When I run sys.dm_db_index_physical_stats, I used the DETAILED option for scan level.
SSMS uses the SAMPLED scan level.
March 18, 2010 at 4:52 am
Are you able to post the CREATE TABLE and CREATE INDEX statements please?
March 18, 2010 at 4:48 am
TheSQLGuru (3/17/2010)
March 18, 2010 at 4:41 am
HowardW (3/18/2010)
Could you post the actual execution plans with and without use of the parameters?
No worries Howard, it is a good point. It is always nice to see execution...
March 18, 2010 at 4:36 am
peleg k (3/18/2010)
1)when i added an index - can i check how long it will take or approximatly how much was done?
How long it will take - no.
How much was...
March 18, 2010 at 4:30 am
GDI Lord (3/18/2010)
Users can be an interesting bunch after all
Amen.
I was going to do it via a for loop in the app, merely KILLing all session ids that are not...
March 18, 2010 at 4:14 am
handkot (2/25/2010)
see this topicmaybe Paul White post help you
:w00t:
March 18, 2010 at 4:07 am
The system view you need is sys.columns, look at the is_nullable column on that view.
The following example shows all objects (tables/views...) in the AdventureWorks sample database that contain a column...
March 18, 2010 at 4:05 am
Steven Jones-245254 (3/18/2010)
Many thanks for the reply. Am currently digesting the article!
It is a lot simpler in practice than it may first appear. The important thing is to make...
March 18, 2010 at 3:48 am
ruchi-761283 (3/17/2010)
I want to know the length of data stored in a table column.
If you are looking for the maximum length of data (in bytes) that the data type of...
March 18, 2010 at 1:57 am
Viewing 15 posts - 5,161 through 5,175 (of 8,416 total)