Viewing 15 posts - 1 through 15 (of 19 total)
GilaMonster (1/6/2011)
January 6, 2011 at 7:22 am
GilaMonster (1/6/2011)
You mean if SQL uses another index? Index scan rather than clustered index scan?
No, I was thinking if the columns needed were not part of the index key,...
January 6, 2011 at 6:46 am
GilaMonster (1/6/2011)
A clustered index scan can return the data ordered by the clustering key, but it's also perfectly possible for it to return the data in no particular order.
If the...
January 6, 2011 at 6:07 am
If I understand correctly, one difference between a clustered index scan and a table scan is the data retrieved via a clustered scan is returned ordered, using the clustered index...
January 6, 2011 at 5:41 am
I've been working from home for a few years now, only going into the office for a once a week staff meeting, and have mixed feeling on the issue. ...
December 29, 2010 at 7:35 am
Being able to use SQLCMD mode in the SSMS I think is a great feature. I tend to write a lot of stand alone scripts, so being able to use...
December 17, 2010 at 8:28 am
Thanks for the tips... I did not empty the mem cache. I will try that. However, I did create a new db just for this purpose, used the...
March 1, 2007 at 8:10 am
To create the 3 tables, I just used select into from the source database to 3 new tables in a new database. The first had no conversions, the second...
March 1, 2007 at 7:42 am
Just a thought... but
Assuming there were no changes to the database structure since it was created, and the log contains all transactions since the sql db was created, couldn't he...
September 14, 2005 at 5:23 am
When you set the @binaryvariable, it is treating the string of 1's and 0's as a decimal, not a binary number. To initialize the var, use hex notation, then...
September 9, 2005 at 8:42 am
entries in the arp table get removed every 2 min or so (on win 2000), if no traffic from host to the net_address. you may need to run arp...
September 8, 2005 at 8:25 am
You could write a batch file to loop though and ping all IPs on your network, which would then fill the arp cache with IP to MAC address mappings...
September 7, 2005 at 8:05 am
Sounds like Access is using the SQL Server Desktop Engine instead of JET, which limits the number or running queries to 8. See this article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_0ciq.asp
and this
September 7, 2005 at 5:53 am
Viewing 15 posts - 1 through 15 (of 19 total)