Viewing 15 posts - 331 through 345 (of 18,926 total)
david.searle (12/16/2011)
I spotted a mistake in my original code too...
I am joining on the sys.tables and sys.indexes tables when pulling back the index data - this doesn't work because...
December 17, 2011 at 5:59 am
Revenant (12/16/2011)
SQLRNNR (12/16/2011)
Ninja's_RGR'us (12/16/2011)
SQL Kiwi (12/16/2011)
GilaMonster (12/16/2011)
SQL Kiwi (12/16/2011)
Connect items are often closed as Won't Fix before an explanation or more details are provided.
Yes, which quite frankly is a problem...
December 16, 2011 at 11:43 am
SQL Kiwi (12/16/2011)
GilaMonster (12/16/2011)
SQL Kiwi (12/16/2011)
Connect items are often closed as Won't Fix before an explanation or more details are provided.
Yes, which quite frankly is a problem in and of...
December 16, 2011 at 11:26 am
Safest path is to do side by side installs (even different machines/vms if possible). That allows you to test as much as you want and you still have the...
December 16, 2011 at 10:52 am
GilaMonster (12/16/2011)
SQL Kiwi (12/16/2011)
Ninja's_RGR'us (12/16/2011)
Connect items are often closed as Won't Fix before an explanation or more details are provided.
Yes, which quite frankly is a problem in and of...
December 16, 2011 at 10:51 am
P.S. Just make sure to not leave it on once you're done, it requires a lot of ressources and in a very worst case scenario it can slow down (halt)...
December 16, 2011 at 10:09 am
pwalter83 (12/16/2011)
Ninja's_RGR'us (12/16/2011)
Keep...
December 16, 2011 at 10:09 am
Ok, so you're all set? Anything else you need hep with?
P.S. Simple mode doesn't stop the tlogs from growing, it just won't happen because someone forgets to take regular...
December 16, 2011 at 10:07 am
The <n> GB limit applies only to the data files, not the logs.
This is one of the good reasons to run a tlog shrink (big delete, grows the log, won't...
December 16, 2011 at 9:45 am
Time to run profiler and see what access sends to sql server. Debug that in SSMS then bring it back to access once it works in SSMS.
Keep in mind...
December 16, 2011 at 9:42 am
try redoing the combo alone on a brand new blank form.
So is it access or sql server (as the datastore)?
December 16, 2011 at 8:57 am
Sapen (12/16/2011)
Hope this helps:http://blog.sqlauthority.com/2008/02/11/sql-server-2005-find-unused-indexes-of-current-database/
http://blog.sqlauthority.com/2011/01/03/sql-server-2008-missing-index-script-download/
This is far more complex than just running scripts, please watch the 3 vids I posted.
December 16, 2011 at 8:44 am
jcrawf02 (12/16/2011)
December 16, 2011 at 8:43 am
Is the data on access or sql server?
If the latter you can run a trace to see what access is sending to sql server.
If the former, go step by step...
December 16, 2011 at 8:43 am
ok, option b is my preffered.
December 16, 2011 at 8:15 am
Viewing 15 posts - 331 through 345 (of 18,926 total)