Viewing 15 posts - 6,106 through 6,120 (of 49,571 total)
N.D (4/22/2015)
I may have misheard, I know that it's using tempdb to help with contention and I always get them muddled up
Both Snapshot and Read Committed Snapshot do that, it's...
April 22, 2015 at 3:14 am
Now that's really weird. A select shouldn't need to be allocating pages and hence should not have to take UP latches on allocation pages.
Why do you have both snapshot and...
April 22, 2015 at 3:06 am
There are many, many, many articles, videos, probably even books on SQL Injection. Please spend some time with google (and with your senior developers) and read up on it. It's...
April 22, 2015 at 3:04 am
Two things.
First, and most important, your procedure is vulnerable to SQL Injection. Please do some reading up on SQL Injection and fix the vulnerability. This should be your top priority...
April 22, 2015 at 2:52 am
Rob Reid-246754 (4/21/2015)
e.g likeUPDATE STATISTICS [dbo].[tbl_TRAFFIC_VISITORS] _WA_Sys_0000000C_1DE57479 WITH FULLSCAN
Yup, exactly like that, although you don't need to specify the stats name, specify the table name and all stats on...
April 21, 2015 at 8:07 am
A product (software product) named "Backup Exec". It's a backup tool used to back up files and machines.
April 21, 2015 at 6:59 am
Use update statistics with the FULLSCAN option.
April 21, 2015 at 6:23 am
domingo.sqlservercentral (4/21/2015)
UPDATE Persons
SET P_Id=0,...
April 21, 2015 at 5:20 am
MotivateMan1394 (4/21/2015)
yesssssssIndex on shceme . (Not on table)
No! Table on partition scheme.
If you want to partition the table, you need to partition the actual table, not one index on...
April 21, 2015 at 5:14 am
domingo.sqlservercentral (4/20/2015)
CONSTRAINT chk_Person CHECK (P_Id>0 AND City='Sandnes')but... it works independly for these columns, as two simple check constraints.
That's one check constraint that checks both columns, it's not two independent...
April 21, 2015 at 5:11 am
N.D (4/21/2015)
The CPU was being hammered at the time, is it possible that this could have contributed to thie contention?
No. GAM pages are only updated (the pagelatch_up) when an...
April 21, 2015 at 4:10 am
MotivateMan1394 (4/21/2015)
But steal the size of my new mdf files are the default size and all data are in old mdf files.
Yes, because you haven't partitioned any of your tables...
April 21, 2015 at 4:08 am
It's the application Backup Exec. The sysadmin probably has it configured to back SQL Server up as well as the machine. Have a chat with him and make sure you...
April 21, 2015 at 3:56 am
N.D (4/21/2015)
This database doesn't have any create / drop table
Weird. You shouldn't be seeing severe GAM contention in a user DB... If it happens again, can you capture the queries...
April 21, 2015 at 3:43 am
An index on a view is only fired if a change is made to the view. It won't fire if you insert/update the tables. Put triggers on the tables for...
April 21, 2015 at 3:26 am
Viewing 15 posts - 6,106 through 6,120 (of 49,571 total)