Viewing 15 posts - 421 through 435 (of 1,222 total)
crazy4sql (6/15/2012)
This took approximately 1 hour to load 168,261 rows.When I used a linked server and a Select into statement it took 10 seconds.
This should not be the...
June 15, 2012 at 5:55 am
I suspect that the performance problem is because the insert destination is committing each row as it goes. Check the insert destination- the data access mode should be something...
June 14, 2012 at 10:21 pm
You could trying using the ReportViewer control as part of your application. I haven't used it but from what I have read, it embeds all of the report logic...
May 29, 2012 at 7:32 am
UDP Port 1434 is used by SQL Server Browser - it is a service that runs on the server where SQL Server is installed and allows applications to find the...
May 27, 2012 at 10:16 pm
UDP Port 1434 is used by SQL Server Browser - it is a service that runs on the server where SQL Server is installed and allows applications to find the...
May 27, 2012 at 10:12 pm
You could apply a filter to the dataset or to the chart itself if you don't want to change the sp - this does assume that the date that you...
May 13, 2012 at 10:38 pm
GilaMonster (5/8/2012)
ashkan siroos (5/8/2012)
it will change 100 MB data to 100MB+ 200 KB which is not important at all.
That's assuming you have only one case where you have a different...
May 8, 2012 at 9:31 pm
I doubt that basing your extraction criteria on the date/time of the last time you extracted data is going to give you the correct result. You really need to...
May 6, 2012 at 10:34 pm
Replication definitely does not like IP addresses. Not sure what you need to a cloud based server
May 6, 2012 at 10:16 pm
The answer is yes to all of your options.
Depending on what options you choose, replication can be told to drop tables, truncate tables, delete from tables. when you create...
April 26, 2012 at 10:22 pm
I don't think that you should be grouping anything.
Also, I suspect that you are attempting to apply formatting etc at the row level of your report. You should be...
April 24, 2012 at 8:18 am
Player is not a junction of players, teams and seasons. It is more like a list of people who play the sport. It may include other information about...
April 24, 2012 at 8:14 am
Perhaps you could think of the relationships like this...
Players are members of a club for a period of time (i.e. they play for one club this year, and a different...
April 23, 2012 at 10:17 pm
To me, that simply means that your condition is not simply
Previous(Fields!HostName.Value) = (Fields!HostName.Value)
It is more like
IIF (Previous(Fields!HostName.Value) = (Fields!HostName.Value)) AND Previous(Fields!Manufacture.Value)...
April 23, 2012 at 8:10 am
Viewing 15 posts - 421 through 435 (of 1,222 total)