Viewing 15 posts - 256 through 270 (of 1,584 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...
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...
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...
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...
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...
March 26, 2014 at 5:42 pm
Did you specify -t 4001 or -T 4001?
Did you restart the SQL Server service?
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...
March 25, 2014 at 1:05 pm
About how many pages are in the indexes you are noticing this on?
Are the tables heaps?
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...
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 😎
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
-...
March 25, 2014 at 8:35 am
@Grant, yeah I had already thrown the bone in that direction 🙂
March 25, 2014 at 7:58 am
Yes, it would help a lot (thanks)
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) -...
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...
March 24, 2014 at 1:34 pm
Viewing 15 posts - 256 through 270 (of 1,584 total)