Viewing 15 posts - 3,361 through 3,375 (of 3,640 total)
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
Is it purely your text fields or have you converted varchar to nvarchar, char to nchar etc?
If you used nchar and nvarchar then not only does the base data take...
December 12, 2003 at 2:37 am
I got caught on this one as well.
If a database is in "simple" recovery mode then the transaction log backup portion of the maintenance plan will fail.
Coming from SQL 6.5...
December 12, 2003 at 2:05 am
Assuming that you have set up your logins set up then to add them into the database you would use:
exec sp_grantdbaccess 'the login','the username in the db'
exec sp_addrolemember 'db_datareader','the username...
December 12, 2003 at 1:47 am
When I was doing Access/SQL work I set up a passthrough query to SQL that ran my record aggregate stored procedure.
I then set up a cross-tab query that used the...
December 9, 2003 at 7:45 am
Are there any updates on this?
The article left off where you were about to upgrade an IIS/SQL box. Has this been done yet and what were the results?
He was...
December 9, 2003 at 4:53 am
We tend to keep our IIS Servers on separate boxes to SQL Server.
We remove PUBLIC permissions to virtually all the stored procedures in the MASTER database because by default any...
December 5, 2003 at 2:23 am
I wouldn't have put it at 3 points and yes and extent was/is 8 contigious pages in SQL.
When I moved from SQL6.5 through 7 to 2000 I must admit that...
December 2, 2003 at 2:15 am
Viewing 15 posts - 3,361 through 3,375 (of 3,640 total)