Viewing 15 posts - 256 through 270 (of 1,583 total)
+1 Jeff
Ultimately you need to test and get an idea of when it's quicker. It often does depend on how much data, and your disk I/O. Are you creating...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 27, 2014 at 12:05 am
You need to open up the Reporting Services Configuration Manager on the server it is installed on, and "Restore" the encrypted key file (you will need the password used to...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 26, 2014 at 11:54 pm
Possibly true, but the OP doesn't really state (or know) anything about the tests at this point. For all we know there's nothing but system databases in existence on...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 26, 2014 at 11:47 pm
If they haven't told you the nature of the test, I'd leave it
(although if you're in a DBA-type role, you ought to have inquired as to the nature of the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 26, 2014 at 7:17 pm
It depends on what is being tested. If they are performance testing queries against the database, then I would recommend you rebuild/reorganize your indexes. If they are testing...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 26, 2014 at 5:42 pm
Did you specify -t 4001 or -T 4001?
Did you restart the SQL Server service?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 25, 2014 at 1:16 pm
You've got some dependency on R_%
"The INSERT statement conflicted with the FOREIGN KEY constraint "R_5""
Temporarily disable the constraint so you can move the data or you can also try using...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 25, 2014 at 1:05 pm
About how many pages are in the indexes you are noticing this on?
Are the tables heaps?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 25, 2014 at 9:07 am
Nevermind about the flat files, I loaded it up on a VM...
The reason its taking a longer time to run with the last line included (AND LIParent.TreeID = LIChild.TreeID) is...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 25, 2014 at 8:59 am
Sorry, but please attach .TXT files for data and table definitions, I'm not going to load your DB onto my system 😎
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 25, 2014 at 8:37 am
To start, I'd recommend setting up default alerts for:
- Error Number 823 - IO/Hardware/System Issue detected
- Error Number 824 - IO/Logical Consistency Check Failed
- Error Number 825 - Read/Retry Warning
-...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 25, 2014 at 8:35 am
@Grant, yeah I had already thrown the bone in that direction 🙂
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 25, 2014 at 7:58 am
Yes, it would help a lot (thanks)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 25, 2014 at 7:46 am
Please. Post. Your. Execution. Plan.
First off, is this a scalar function in your JOIN? It's looks like one but want to be certain before jumping to any conclustions: IsDescendantOf(LIParent.HID) -...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 25, 2014 at 7:32 am
If you can't find the error in the SQL Server Error log, I would pretty much guarantee that it's not SQL Server throwing the error. Sounds more like the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 24, 2014 at 1:34 pm
Viewing 15 posts - 256 through 270 (of 1,583 total)