Viewing 15 posts - 5,176 through 5,190 (of 22,211 total)
Yeah, what can you see from the SQL Server side? Is the process blocked or waiting on a resource or what? That's what I'd want to know.
January 25, 2016 at 6:07 am
It's possible that you're experiencing CPU pressure. Those queries are horrific. However, changing your max degree of parallelism is only going to make those queries run in a serial mode....
January 24, 2016 at 8:46 am
High CXPACKET waits are an indication of parallel query execution, but not an indication that parallel execution is causing problems on your server. You need to look to other wait...
January 22, 2016 at 8:26 am
That wait type is not very descriptive and is usually nothing to worry about. However, it can be an indication of issues with the query itself. Rather than focus on...
January 22, 2016 at 2:44 am
ramana3327 (1/21/2016)
So triggers are the only option if you don't want have any 3rd party tools!
Well, extended events are not a third party tool. You would have to write some...
January 21, 2016 at 3:17 pm
The most effective way you can have this done from within SQL Server itself is through triggers. You can set up extended events to capture the changes... it's going to...
January 21, 2016 at 11:15 am
Hugo Kornelis (1/21/2016)
January 21, 2016 at 6:05 am
salardx (1/21/2016)
We CANNOT have much indexes in the tables (neither one table for each month, nor 10,000 tables!)
because data is bulking into the tables! 1000 records on each bulk!...
January 21, 2016 at 5:33 am
Please, please, please, I already feel like I've been picking on this person, so no piling on. But they're looking for help and I don't think I'm providing it in...
January 21, 2016 at 5:09 am
salardx (1/21/2016)
Do any of the files that you load have the same structure? If so, why not put them into the same table? And why create a new database each...
January 21, 2016 at 5:07 am
The very best way to deal with scale is start with the fundamentals. Making good choices on the clustered index, primary key (not the same things), unique constraints, normalization, data...
January 21, 2016 at 4:02 am
I don't understand what you're going for. When you say you want to "check five columns uniqueness by checking one column" you're stepping outside of standard mechanisms.
What I'm suggestion is...
January 21, 2016 at 3:22 am
There are lots of ways to document a procedure. It really depends on why you're documenting it, for what purpose, for what audience.
One option is to look to a third...
January 21, 2016 at 2:25 am
bebe022476 (1/20/2016)
Here it is:
DocumentID(PK,int,not null)
DocFolderID(int,null)
PublishToWeb(bit,null)
Filename(varchar(100),null)
Filesize(int,null)
ModifiedDate(datetime,null)
TableName(varchar(40),null)
EntityCode(varchar(12),null)
I'm not sure how to attached the jpg screenshot here but the execution plan only has 100% Clustered Index Scan(Clustered) on [document],[pk_document] .
The job normally...
January 21, 2016 at 2:22 am
Viewing 15 posts - 5,176 through 5,190 (of 22,211 total)