Viewing 15 posts - 1,546 through 1,560 (of 7,168 total)
Even though estimated cost is well over 20, i still see query using all the cores?
Cores, or threads? What exactly are you seeing that is making you think it is...
March 19, 2013 at 11:26 am
Sqlism (3/19/2013)
Help Please
What are you having trouble with?
March 19, 2013 at 11:14 am
Some itesm that jumped out at me readnig your post.
I have four temp dbs (100 meg and three 200 meg--which I want to set all to 100) one...
March 19, 2013 at 10:00 am
I actually modify the default Agent history settings so that noisy jobs do not force important job history to be deleted. I have a job on all my instances that...
March 19, 2013 at 9:46 am
I am assuming you meant Logins and not Users. Users are at the database level and are stored within the databases themselves so should come over when you restore the...
March 19, 2013 at 9:41 am
Restoring a 2008 R2 backup to a 2012 instance means the restore process has to do an in-place upgrade of the involved database files which can add time to the...
March 19, 2013 at 9:35 am
1- Does the ftp task in ssis have to do anything with this PGP public key?
This has nothing to do with SSIS or FTP. PGP is an encryption technology commonly...
March 19, 2013 at 9:28 am
GilaMonster (3/19/2013)
TheSQLGuru (3/19/2013)
The DOP of said plan will not be higher than MAXDOP setting of server or the MAXDOP query hint if one is used, whichever is lower.
The query hint...
March 19, 2013 at 9:11 am
sqldba_newbie (3/18/2013)
opc.three (3/18/2013)
Cost estimate compared to the Cost threshold for parallelism setting. The QO is a cost-based optimizer.Thanks. Do you mean Cost from estimate plan?
Yes. There is only an estimated...
March 19, 2013 at 7:46 am
Why re-invent the wheel? The scripts provided at the link below will do what you need, will take only minutes to setup and are run all over the world by...
March 19, 2013 at 1:05 am
ESAT ERKEC (3/19/2013)
[ID] [int] NULL,
[NAME] [varchar](100) NULL,
[SURNAME] [varchar](200) NULL
) ON [PRIMARY]
GO
TAB -1
I m trying
BEGIN TRAN
SELECT ID FROM TESTROWLOCK WITH(ROWLOCK) WHERE ID=2
TAB-2
SELECT ID FROM TESTROWLOCK ...
March 19, 2013 at 1:01 am
chewychewy (3/19/2013)
Hi Guys,I'm going to reorganize indexes with > 10%.
Is there a need to update statistics after the re-org?
No need.
From the 2008 R2 article http://msdn.microsoft.com/en-us/library/ms190397(v=sql.105).aspx:
Do not update statistics after operations...
March 19, 2013 at 12:47 am
Why are you shrinking your transaction log? If it grew to 23 GB due to normal activity then it will only grow again to the previous size and you'll be...
March 19, 2013 at 12:42 am
This book could help you.
http://www.amazon.com/Microsoft-Server-2012-T-SQL-Fundamentals/dp/0735658145/ref=rec_dp_2
March 19, 2013 at 12:27 am
Viewing 15 posts - 1,546 through 1,560 (of 7,168 total)