Viewing 15 posts - 1,546 through 1,560 (of 7,164 total)
Sqlism (3/19/2013)
Help Please
What are you having trouble with?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 19, 2013 at 11:14 am
Server-side Trace or Extended Events session.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 19, 2013 at 10:04 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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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 ...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 19, 2013 at 12:27 am
Cost estimate compared to the Cost threshold for parallelism setting. The QO is a cost-based optimizer.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 18, 2013 at 4:34 pm
Viewing 15 posts - 1,546 through 1,560 (of 7,164 total)