Viewing 15 posts - 3,226 through 3,240 (of 9,725 total)
ChrisM@Work (4/22/2014)
Does anyone around here know anything about output lists from index seek operators, by any chance? Don't all raise your hands at once, you might drop your rod...
What are...
April 22, 2014 at 6:53 am
qew420 (4/21/2014)
...
I can check the missing Indexes but again only counting the # of records .. system...
April 22, 2014 at 4:36 am
*THAT* is a filleted fish?
Ummm, would you take it the wrong way if I begged you to keep your day job and forget about opening that restaurant? @=)
April 22, 2014 at 4:28 am
It doesn't matter that everything was good until Replication was added. When you added Replication onto the server, you added an extra load plus you added a whole bunch of...
April 22, 2014 at 4:22 am
Hey, run this script on the Subscriber and see if you're getting lots of small waits or some (or lots) of long waits. Post the results, please.
select * from...
April 21, 2014 at 10:55 am
:crying:
Why, oh why, oh why do people insist on pulling scripts off the internet then asking us to modify them to do what they want the scripts to do without...
April 21, 2014 at 10:52 am
I do not think your issue is Replication. I think it is either I/O or bad indexes (or both).
A few things to look at on your side:
How wide is your...
April 21, 2014 at 10:46 am
Not immediately. I'm in the middle of my own urgent project. But I will work on it as I have time. In the meantime, if you know how to do...
April 21, 2014 at 10:34 am
It works the same way.
Edit: Just realized you were referring to a system proc, so deleting my previous statement. Google the error you received when you put in the...
April 21, 2014 at 7:56 am
That works wonderfully. Thanks.
April 21, 2014 at 7:08 am
Brandie Tarvin (4/21/2014)
How do I figure out what the problem is when I add a reference and it has the yellow warning next to it?
Nevermind. I'm in brain-dead mode this...
April 21, 2014 at 6:30 am
How do I figure out what the problem is when I add a reference and it has the yellow warning next to it?
April 21, 2014 at 6:26 am
Eirikur Eiriksson (4/21/2014)
Open the Script Task Editor and choose Edit Script. In the VSTA editor, select Project menu and Add Reference...😎
Oh, good grief. I'd never have found that. Thank you.
April 21, 2014 at 6:23 am
The thing about ordering is that it never works quite the way you expect. The individual columns are all associated with one record, so you can't get every column to...
April 21, 2014 at 5:43 am
The column you are looking for is type_desc in sys.server_principals.
April 21, 2014 at 4:40 am
Viewing 15 posts - 3,226 through 3,240 (of 9,725 total)