Viewing 15 posts - 2,881 through 2,895 (of 3,656 total)
2Gb of data. War and Peace in PDF form is only around 200Mb.
February 10, 2005 at 2:43 am
I visited northern Massachussets where it takes 15 minutes to walk off your own property and I would guess that identity theft would not be a problem there.
I live in...
February 10, 2005 at 2:42 am
If you are just interested in people of 17 or over then add WHERE age>=17 to your SQL, then a simple COUNT(*) will be the sum.
February 10, 2005 at 2:34 am
The looping around the a select statement works quite well because the locks are only held for a short period of time.
February 9, 2005 at 8:45 am
We have a recycling scheme in my local area so all junk mail goes straight in the recycling bag.
It is the plastic tat from McDonalds happy meals that bugs me!
In...
February 9, 2005 at 8:34 am
If you use a user defined function in this way then I believe that SQL will use an implicit cursor because the function has to work on a row by...
February 9, 2005 at 2:53 am
Try http://spambayes.sourceforge.net/windows.html
You have to install Python on your PC but it is easy enough to install.
Make a folder in outlook and store all your spam in it until you have...
February 9, 2005 at 2:02 am
You can happily fire off stored procedures from within stored procedures.
Let us suppose you have a return value. You could include syntax as follows
DECLARE @lResult Int
exec @lResult=usp_myproc
If you...
February 9, 2005 at 1:56 am
Pretty unanimous opinion here Steve. I'm afraid you are just going to have to keep writing those editorials!
February 8, 2005 at 1:39 am
Using the Outlook 2003 blocked senders facility I blocked 113 SPAMS this morning.
Every morning I add between 20 and 30 new addresses to the list.
Theoretically I should trawl through the...
February 8, 2005 at 1:35 am
And of course having a son who can jump start a car without tools is always a blessing!
I wonder if they are still looking for extras in the next X-men...
February 7, 2005 at 9:21 am
During the first year your hi-fi and personal possessions are safe.
You put the baby down it stays put.
After that they follow you EVERYWHERE and get into EVERYTHING.
Blackcurrant juice...
February 7, 2005 at 4:05 am
There are two ways to do this.
1. Use either a TEXT or NTEXT field.
2. Compress your string in some way
Personally, I would go with option 1.
Option 2 is messy and...
February 7, 2005 at 1:28 am
Access is famous for causing locking problems with SQL Server.
Try creating a views for each of your SQL Server tables as
SELECT [field1]....[fieldn]
FROM dbo.YourTable WITH NOLOCK
Then try connecting these to your...
February 5, 2005 at 5:21 am
The easiest way is to use Enterprise Manager.
right-click on TempDB and adjust the size under the Data Files and transaction log tabs.
February 4, 2005 at 10:36 am
Viewing 15 posts - 2,881 through 2,895 (of 3,656 total)