Viewing 15 posts - 766 through 780 (of 1,315 total)
Are you sure about the units are on the queries you ran? I checked a couple of my SQL 2000 servers and msdb.dbo.RTblClassDefs was exactly the same size as yours,...
August 29, 2006 at 12:48 pm
DECLARE
@IDlist TABLE (
ID int NOT null,
seq int
August 29, 2006 at 11:49 am
I am not aware of any performance difference. I find CAST more readable, but CONVERT provides an extra Style parameter to control formatting. Use whichever one makes you happy.
August 10, 2006 at 4:36 pm
Why do a CONVERT on every row? CONVERT the SUM instead:
SELECT
CONVERT(double, SUM(RiderCount
August 10, 2006 at 2:48 pm
There should be locks created by anyone accessing the view. This query should tell you the SPID for someone using the view MyDB.xyz.MyView
SELECT
DISTINCT...
August 10, 2006 at 2:32 pm
The real concern would be how to dispose of the bodies of the miscreants putting 1kb files on my data drives.
August 10, 2006 at 11:45 am
The recommended block size for SQL Server is 64K, because that is the size of most SQL Server I/O operations. Whether or not that trumps the recommendation in the hardware...
August 10, 2006 at 9:33 am
It sounds like she needs to learn to open the Access project exclusively before she starts coding. If that is unacceptable because other users need frequent access, she needs to learn the...
August 4, 2006 at 10:51 am
VB 6 and Access are very similar, but sometimes not as similar as they appear. Working with Access tables should be about as easy and familiar in VB6 as in...
August 3, 2006 at 3:35 pm
The idea that a column has the same datatype for every row is pretty fundamental. If you really wanted a column to be VARCHAR in some rows and BIT in...
August 2, 2006 at 9:42 am
Asking if VB is a "better platform" is incredibly vague. VB is more powerful, but also more general-purpose. There will be a learning curve involved, bad enough with VB6 but...
August 2, 2006 at 9:30 am
The DTEXEC command will run a package, if Access has some version of a Shell function to run it. You can use xp_cmdshell (if it is enabled) to run a...
August 2, 2006 at 8:52 am
Now that we've given you some ideas to work on, I'm going to suggest that you look for another approach. Cleaning addresses is very messy. If this is a one-time...
August 1, 2006 at 1:57 pm
The sp_delete_backuphistory procedure uses a cursor to go through one backup event at a time and delete all related records in backuphistory, backupfile, backupset, backupmediaset, backupmediafamily, restorehistory, restorefile, and restorefilegroup. ...
August 1, 2006 at 11:48 am
Here's an example: http://www.sqlis.com/default.aspx?37
July 31, 2006 at 2:28 pm
Viewing 15 posts - 766 through 780 (of 1,315 total)