Viewing 15 posts - 15,121 through 15,135 (of 49,552 total)
stryk (12/21/2012)
But they ran the Index Rebuild on that table which seems to help a lot! So, for now we will schedule this maintenance daily ...
No, don't. Run an Update...
December 21, 2012 at 12:44 am
ico-601891 (12/21/2012)
What is better to have a unique datafile or have multiple datafile for better performance
It depends. There is no simple answer to that question. Depends on the physical...
December 21, 2012 at 12:43 am
Why looping? SQL doesn't need any form of looping to get master-detail information. You'd write a single query with a join across the two tables. Something like this:
SELECT Master.Col1, Master.Col2,...
December 21, 2012 at 12:40 am
Please post the deadlock graph and the definition of all indexes on the involved tables.
December 21, 2012 at 12:39 am
David Paskiet (12/20/2012)
There has to be an easier way! I am all ears and open to a better way!
See the kb article referenced in the article I mentioned.
December 21, 2012 at 12:37 am
Josh Ashwood (12/20/2012)
GilaMonster (12/20/2012)
Can you imagine all the simple
SELECT Foo FROM Foo, Bar WHERE Foo.X *= Bar.Y
haha *=
Now that is real dinosaur stuff!!
You'd think so,...
December 21, 2012 at 12:37 am
Bhuvnesh (12/20/2012)
GilaMonster (12/20/2012)
You specified the partition ranges yourself.CREATE PARTITION FUNCTION PartitionDB_PartitionRange (INT)
AS RANGE LEFT FOR VALUES (500,1000,2500);
So here partition 1 means "Less than 500" ?
That's what your partition function...
December 21, 2012 at 12:35 am
Err...bad idea. Really bad idea.
One file per core is an old recommendation, it's not a good idea under all circumstances without consideration or investigation.
December 20, 2012 at 12:26 pm
Run CheckDB with the Data_Purity option. For Resolving the error, see the section in this article on data purity errors and the kb article it links to.
December 20, 2012 at 12:23 pm
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
DBCC TRACEON(1222,-1)
Please...
December 20, 2012 at 10:41 am
npranj (12/20/2012)
Would this help?WAITFOR DELAY '00:00:00.05' -- Wait for 5 ms
As in, if you get a deadlock, ignore it and try again, repeat until successful? Sure, I wouldn't call it...
December 20, 2012 at 10:17 am
If you're thinking of automatically, with no investigation, creating any indexes suggested by the missing index DMVs and dropping any that the index usage stats say are unused, don't.
Missing indexes...
December 20, 2012 at 9:40 am
Let me guess... Full recovery model and no log backups. When maintained properly, the space in the log file is reusable. See the recommended article
December 20, 2012 at 7:53 am
It can read any page that is in the database. Like with all other operations that read pages, it will read the page from cache. If the page isn't in...
December 20, 2012 at 7:52 am
You specified the partition ranges yourself.
CREATE PARTITION FUNCTION PartitionDB_PartitionRange (INT)
AS RANGE LEFT FOR VALUES (500,1000,2500);
December 20, 2012 at 7:20 am
Viewing 15 posts - 15,121 through 15,135 (of 49,552 total)