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
#1682991
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
#1682990
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
#1682987
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
#1682986
Or rebuild the system databases and re-attach the database files.
http://technet.microsoft.com/en-us/library/dd207003.aspx
January 20, 2014 at 4:29 pm
#1681701
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
#1681698