Viewing 15 posts - 48,946 through 48,960 (of 49,552 total)
I haven't seen that error since I did web dev some years back, but then it was because of the cursortype and lock type. There are some combinations that aren't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 8, 2006 at 4:05 am
Because drop table is a logged operation and you are reqesting a rollback ie undo everything up to where the transaction began.
By the way, your code shouldn't even run. You...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 8, 2006 at 3:34 am
Can you post the code of the stored procedures and the table structure please
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 8, 2006 at 3:31 am
Yes, it's one of the new SQL 2005 DM views. Since this is the SQL 2005 forum, I did the 2005 solution.
You can do the same thing with sysprocesses in...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 8, 2006 at 12:26 am
Again, 5 users (5 different user names) or 5 connections? Is a single user allowed to make multiple connections to the database, and if so, do you count each of them,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 7, 2006 at 3:11 am
How many users, or how many connections?
For number of connections,
SELECT
count(*) FROM sys.dm_exec_connections
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2006 at 11:58 pm
Yeah, that will work better. Thanks. I overlooked the negating of conditions when I read up on LIKE
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2006 at 10:49 pm
If you define a data type as varchar without specifying a length, you get a varchar of length 1, hence all that you have in your variables is '1'. It's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 6, 2006 at 5:09 am
IsNumeric will work, but it will allow through some character data
SELECT
IsNumeric ('125D256') Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We stand on the bridge and no one may pass
November 6, 2006 at 12:12 am
Nope, sorry. You're going to have to get used to typing.
You can get management studio/enterprise manager to generate an update statement for you that at least has the full list...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 3, 2006 at 2:24 am
Make the column an identity. Let SQL worry about the next number.
If you do increments yourself, unless you're very careful with transactions, you could end up with duplicate values (or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 3, 2006 at 2:16 am
See if you can get hold of the SQL Server 2005 upgrade adviser. It's probably available for download from MS.
With the testing I'm doing for upgrades, it's not so much...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 3, 2006 at 12:13 am
What does the execution plan look like with the isnull and without it?
If it's a stored procedure, it may be getting a bad execution plan. If the optimiser compiles for...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 2, 2006 at 11:32 pm
My main server has 2 heavily utilised large databases and a few smaller, less used ones.
We split the biggest database into 3 data files and put each one on a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2006 at 11:52 pm
Is there any trigger on the Address table? Are any errors been raised?
Are you using a cursor for the Address update as well? If so, I may have an idea...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 1, 2006 at 10:55 pm
Viewing 15 posts - 48,946 through 48,960 (of 49,552 total)