Viewing 15 posts - 6,286 through 6,300 (of 22,211 total)
You must have a primary key or a unique constraint in one table in order to match that table to another through a foreign key constraint. Further, the data types...
April 16, 2015 at 6:15 am
No. There's no log file showing temporary table creation and drops. Also, you can't reference a standard temporary table between sessions. You would have to create a global temporary table...
April 16, 2015 at 6:11 am
Or, check out Minion Reindex which is available here[/url].
Assuming your maintenance plan is being run by SQL Agent, you can try outputing everything from Agent to a file. It's a...
April 16, 2015 at 6:08 am
Pretty sure it's microseconds on rpc_completed and sql_batch_completed. However, it does depend on which event you're looking at. Unfortunately, Microsoft has been inconsistent and hasn't documented well. Vote that up...
April 16, 2015 at 6:04 am
Do you mean maintenance scripts?
If so, go here. You can see a number of different utilities for index maintenance, backups, and all sorts of other things.
April 16, 2015 at 6:00 am
Then I'm not sure I understand what's happening. sorry. Can you post a screen shot or two with the list? Hide the names if you need to. Or, you might...
April 16, 2015 at 5:39 am
No, that would show up as differences. Have the table names and or schema's been changed? If they're named differently, our tool can't figure out that TableA ought to be...
April 16, 2015 at 4:48 am
Third party tool like SQL Data Compare [/url]is a great way to get something like this done.
DISCLAIMER: I work for those guys.
April 15, 2015 at 11:44 am
Everything Kevin said.
Plus, if you know the queries that are giving you problems, can you look at the execution plans and, if possible, look at them prior to the upgrade....
April 15, 2015 at 11:41 am
Sounds like the default will be fine. Do you normally change the collation?
April 15, 2015 at 11:37 am
SQLRNNR (4/15/2015)
Ed Wagner (4/15/2015)
BWFC (4/15/2015)
Eirikur Eiriksson (4/14/2015)
Grant Fritchey (4/14/2015)
And this makes 14,001 posts. My fingers are tired.Did you mean 0x3A99?
😎
I thought that too....Unless he posted really fast over night:-D
I figured...
April 15, 2015 at 11:17 am
Also, it's really important that you don't attach massive significance to a single counter. Page Life Expectancy (PLE) is a decent measure of the behavior of some aspects of memory...
April 15, 2015 at 7:27 am
No, they meant for you to use the REPLACE function in a query.
April 15, 2015 at 4:36 am
You need to do this now. Run DBCC CHECKDB. Identify the objects that have allocation issues. You might get lucky. If it's a nonclustered index you can just drop and...
April 15, 2015 at 4:35 am
If you schedule this to run through SQL Agent, the most common method. You can do two things, make sure that on an error it sends an email message is...
April 15, 2015 at 4:22 am
Viewing 15 posts - 6,286 through 6,300 (of 22,211 total)