Viewing 15 posts - 2,386 through 2,400 (of 3,616 total)
Windows for Warehouses? Shortly after the release of Windows for Workgroups.
Then there was a Geordie version of Windows.
For those of you who don't know what Geordies are, they...
March 3, 2006 at 1:32 am
One of the great disillusionments of my career is seeing the backend databases for applications that are making money hand over fist.
I would agree that many of the database designs...
March 2, 2006 at 12:08 pm
I didn't argue for well tested stored procedures replacing DRI. That was the opinion of Phil Factor.
I strongly believe that whether to use DRI is a design issue and...
March 2, 2006 at 10:12 am
Possibly something to do with the time taken to open/close a connection to the database?
March 2, 2006 at 7:14 am
What I meant was that, depending on the tool and font, double underscore is not visibly that different from single underscore.
March 1, 2006 at 2:22 am
COS(1) produces 0.54
SIN = Opposite/Hypotenuse
COS = Adjacent/Hypotenuse
TAN = Adjacent/Opposite
SIN, COS, TAN functions in SQL server work on radians NOT degrees. As a circle is represented by 2 PI radians...
March 1, 2006 at 2:00 am
I would steer well clear of depending on sp double-underscore as a determiner for bespoke stored procedures.
Firstly, a double-underscore isn't obviously different from a single underscore.
Secondly, I feel it...
February 28, 2006 at 9:37 am
Take a step backwards.
What is the business problem that you are trying to solve
February 28, 2006 at 1:22 am
The way that I do it is to create a standard batch file that contains a bunch of OSQL scripts.
All my objects are generated in scripts which I break down...
February 24, 2006 at 12:50 pm
In hindsight, no.
With foresight:
Do the update with a begin transaction but commit transaction commented out. If you get an unexpected number of records updated then run the commit.
My...
February 18, 2006 at 1:31 pm
Look at their book list
The professional Sql server DTS by Wrox is OK but I wouldn't pay full wack for it as it is a little dated now.
If...
February 18, 2006 at 1:28 pm
If you look in sysindexes and look at any clustered indexes there is a rowcnt field that contains the approximate count for the number of rows in the tables to...
February 17, 2006 at 1:16 pm
Firstly add the path of the WZZIP.EXE files to the PATH environment variable. Having done so restart MSSQLSERVER and SQLSERVERAGENT. You should now be able to call WZZIP...
February 17, 2006 at 7:33 am
This suggests to me that if you have a SQL Server with 4GB RAM then there is little benefit in allowing it to look beyond the 2GB threshold?
The...
February 17, 2006 at 3:35 am
Count(Field) will produce a count of the non-null values so you have to use count(*) or count(1) in any case.
Try running DBCC UPDATEUSAGE(0) then running sp_spaceused
February 17, 2006 at 1:37 am
Viewing 15 posts - 2,386 through 2,400 (of 3,616 total)