Viewing 6 posts - 16 through 21 (of 21 total)
The connection protocol is often decided by those that wrote the client software
and what they decided to develop their software in:
Roughly, but not exclusive or correct in all cases.
OLEDB...
January 23, 2014 at 8:15 pm
It's query and data caching that will speed this up the second and third time round.
I find
DBCC DROPCLEANBUFFERS
will probably get you back to the 70sec mark,
but to get...
January 23, 2014 at 8:05 pm
TBOSTWICK-LT - is this the right SQL server?
Do you have two (or more) instances of SQL server installed?
Open SSMS and run
select @@Servername
if the result is not the same as...
January 23, 2014 at 7:33 pm
The 10GB limit for Express is the size of the MDF.
It does not include the LDF. That can actually be as large as it wants to be.
You can also have...
January 23, 2014 at 7:24 pm
Or rebuild the system databases and re-attach the database files.
January 20, 2014 at 4:29 pm
SQL Server tries to determine the order of the articles, but if it is not working, you may need to set the
@processing_order yourself
http://msdn.microsoft.com/en-us/library/ms147310(v=sql.90).aspx
January 20, 2014 at 4:23 pm
Viewing 6 posts - 16 through 21 (of 21 total)