Viewing 15 posts - 3,331 through 3,345 (of 3,617 total)
Perhaps you should write an article and submit it to the site.
Enlighten us all and earn US$25 in the process.
========================
He was not wholly unware of the potential lack of insignificance.
December 17, 2003 at 7:17 am
Yep, Douglas Adams.
The robot was Marvin the paranoid android but I'm thinking of a character in a later book in the series but can't think of his name.
There...
December 17, 2003 at 7:16 am
Sorry, forgot the language barrier.
They say that eskimos have thousands of names for snow, the British have millions that can be used as insults.
Bodily parts can be used as insults...
December 17, 2003 at 4:25 am
I used to work on an HP3000 mini-computer where the console had ultimate control followed by administrators followed by users.
We had a utility that let us impersonate differing levels of...
December 17, 2003 at 3:29 am
In my environment yes because
December 17, 2003 at 3:05 am
As a DBA I expect all submitted code to be commented.
The comments should detail up front which tables are going to be used, what variables if any are declared and...
December 17, 2003 at 1:56 am
Do you mean the physical size of the database or the amount of data within the database?
If you use sp_helpfile within your database this will give you the files used...
December 16, 2003 at 1:12 pm
I've had situations where I have had to use cursors.
I had a recordset containing the stages in securing a sale for customers.
The complete set of stages was called a chain.
Certain...
December 16, 2003 at 5:12 am
quote:
SQL Server is based on the relational model ....but not a very good implementation of it.Of course, since SQL Server is not...
December 16, 2003 at 3:45 am
I would add that stored procedure names should not start with sp_ because SQL Server will search the MASTER database for the stored procedure first and then the user database....
December 16, 2003 at 2:06 am
It looks like you are creating two indices on the SID column of your tables.
To compound it, one is the primary key and the other is a unique index.
CREATE TABLE...
December 16, 2003 at 1:57 am
quote:
UPDATE aSET a = b.a,
b = b.b,
c = b.c,
d = b.d
FROM a,b
WHERE a.id = b.id
December 16, 2003 at 1:49 am
In short, SQL Server works best with sets of data rather than at an individual record level so in most cases eliminating cursors will yield a performance boost.
Cursors are there...
December 16, 2003 at 1:42 am
I'm not sure if this helps because it loops through your table and your data within a stored procedure.
CREATE PROC usp_SplitMyBigText AS
SET NOCOUNT ON
declare @lId...
December 15, 2003 at 2:39 am
Nice summary.
The one thing that puzzles me is that in SQL6.5 we used the sp_addalias in order to alias users to the dbo as there wasn't a db_owner role.
This got...
December 12, 2003 at 3:45 am
Viewing 15 posts - 3,331 through 3,345 (of 3,617 total)