Viewing 15 posts - 11,341 through 11,355 (of 22,214 total)
Or read the book in my signature.
Optimizing stored procedures is a HUGE topic.
February 2, 2012 at 5:47 am
A primary key uniquely identifies a row. Let's say you make a primary key on the alphabet. You can insert a value for 'a', and another for 'b', and one...
February 2, 2012 at 5:46 am
One phrase sticks out "Made a copy"
Does that mean you ran "BACKUP DATABASE..." or that you copied files?
Assuming it is a backup, check the header. You might find that there...
February 2, 2012 at 5:42 am
Not knowing your exact structure, I'm speculating some here...
There are two kinds of indexes, clustered and non-clusterd. You get one clustered index per table. If you're getting a table scan,...
February 2, 2012 at 5:22 am
If you have a unique index, it prevents duplicate data. It doesn't matter if you're updating to duplicate the data or inserting to duplicate the data. You can't have duplicate...
February 2, 2012 at 5:18 am
Tech on Tap is a free event, single tracked on one topic, yesterday's was on Virtualization. There were three 90 minute sessions and time for networking and questions in between....
January 29, 2012 at 7:47 am
Any other List members going to Tech on Tap today? It's shaping up to be an excellent event.
January 28, 2012 at 5:34 am
Really? I thought saying Visual Studio and the compliance checks was a direct answer...
Anyway, SQL Cop is also worth a look. I wrote a review of it here[/url].
January 24, 2012 at 1:51 pm
Yes, it covers all objects. Same with SQL Search.
I work for Red Gate.
If you're entering into a major redesign of the database where you're going to be making lots...
January 22, 2012 at 5:22 am
But, on the question of "Too Many Tables to Join"? No, I don't think 10 is too many tables. I wouldn't even worry about "too many" until I was looking...
January 22, 2012 at 5:18 am
Do you have auto-shrink turned on with any of your databases?
January 22, 2012 at 5:14 am
You might get some information if you look at sys.dm_exec_requests. It will show you if the process is waiting on something or blocked by something. It may also show you...
January 22, 2012 at 5:13 am
Welsh Corgi (1/20/2012)
Grant Fritchey (1/20/2012)
It means it waiting on something. You need to figure out what it's waiting on.BTW, doesn't sound good.
Grant,
Thanks. What is weird is I executed the jobs...
January 20, 2012 at 8:13 am
It means it waiting on something. You need to figure out what it's waiting on.
BTW, doesn't sound good.
January 20, 2012 at 7:44 am
GilaMonster (1/20/2012)
Grant Fritchey (1/20/2012)
GilaMonster (1/20/2012)
Grant Fritchey (1/20/2012)
January 20, 2012 at 7:42 am
Viewing 15 posts - 11,341 through 11,355 (of 22,214 total)