Viewing 15 posts - 196 through 210 (of 218 total)
Ok...I think this is a little closer to the answer you are looking for.
Q1) I have a filegroup with two files. I add a third file, use some of the...
June 7, 2011 at 12:47 pm
I believe this is what you are looking for.
"SQL Server 2000 files can grow automatically from their originally specified size. When you define a file, you can specify a growth...
June 7, 2011 at 12:23 pm
If your just looking to find dupliate vaules. The following would work:
SELECT INVOICE, MEASURE, COUNT(*)
FROM IDXRaw
GROUP BY INVOICE, MEASURE HAVING COUNT(*) > 1
June 7, 2011 at 12:11 pm
Sorry yes. The following would be an example of a failure...yes if you get a blank screen then yes you are connected.
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft...
April 6, 2011 at 2:30 pm
A quick way to determine is a default install of SSAS is installed is to run the following from command line
telnet <server_name> 2383
If it connects then chances are you have...
April 5, 2011 at 1:28 pm
@opc.three
MAXDOP is set to 0. It's running on a system with the 2 sockets and dual core processors.
I'll take a look at the article you attached.
It did teach...
March 30, 2011 at 8:08 am
loki1049,
High level here is what is being said.
Right now you are backing up date database using FULL backups only and you have the database set to FULL recovery.
What is happening...
February 4, 2011 at 2:22 pm
TheSQLGuru (2/3/2011)
February 3, 2011 at 11:20 am
Please see the attached actual execution plans. One useing the address search and the other useing a taxid search.
The address search tool around 5 minutes the taxid search took about...
January 27, 2011 at 9:31 am
shaun.stuart,
I ment a column...for example by taxid, customerid or another unique value that has an index.
The following script was the one they ran to rebuild the index.
EXEC sp_updatestats 'resample'
EXEC sp_MSforeachtable...
January 27, 2011 at 9:03 am
Thanks guys. Yes I agree with some modifications we should be able to improve the performance. Since I'm not able to recreate what was being called when it...
January 26, 2011 at 8:41 am
Attached is the exectuion plan when it is performing poorly. I don't have any information at this time for when it is execution well.
I have modified the results to...
January 24, 2011 at 8:01 am
No when I was doing my T-SQL Test I was the only one on the system and nothing else was running at the time.
I have rebuild index and update statistics...
January 21, 2011 at 2:49 pm
Stad,
Sorry. I thought I notifications turn on for this topic.
I'm not sure. I tested that configureation and I had a user that didn't have access and granted just...
January 20, 2011 at 2:13 pm
Just want to make sure of your security is it like this
DataSources
UserA Browser
UserB Browser
Report Model 1
...
January 18, 2011 at 2:22 pm
Viewing 15 posts - 196 through 210 (of 218 total)