Viewing 15 posts - 42,901 through 42,915 (of 49,552 total)
Can you post one of the CREATE LOGIN statements that the script generated?
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 27, 2008 at 12:49 am
shekihan (11/26/2008)
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 27, 2008 at 12:47 am
madhu.arda (11/26/2008)
Thanks Gail,is that must and should to enable page level locking for all the indexes?
No. It will enable page locks for the index specified in the alter index statement
what...
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 27, 2008 at 12:43 am
ALTER INDEX < Index name > ON < Table Name >
SET (
ALLOW_PAGE_LOCKS = ON
)
GO
Also you may want to revise that script. Both showconting...
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 26, 2008 at 4:19 pm
Please don't cross post. It just wastes people's time and fragments replies.
Besides, I've already answered your post over here: http://www.sqlservercentral.com/Forums/Topic609456-147-1.aspx
No more replies to this thread 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 26, 2008 at 4:05 pm
v.reddy (11/26/2008)
You're welcome to check books online. All of the events are there along with their descriptions.
i belive trace will show...
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 26, 2008 at 3:57 pm
No. Just try not to have multiple constraints/unique indexes on the column(s) referenced by the key.
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 26, 2008 at 2:39 pm
You need to concatenate the variables into the string (beware SQL injection). They way your dynamic SQL is currently written, SQL's looking for two table variables, called @TableInput and @TableOutput...
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 26, 2008 at 2:35 pm
I'm not a fan of dynamic SQL either, but it's the only practical way to get this working with more than around 3 parameters. With 3 or less, you can...
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 26, 2008 at 2:31 pm
All of the foreign keys that the query return reference the Names table. Try dropping them.
It's odd, they should be referencing the pk, not the unique index.
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 26, 2008 at 2:28 pm
dg (11/26/2008)
Now we are getting somewhere,
I'm sorry if the support here isn't up to your expectations.
verify that SQL Server is configured in Mixed Authentication Mode
As I said 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 26, 2008 at 2:27 pm
You already have the query. All you need to do is create the table to match and then convert the select to an insert. All that required is adding the...
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 26, 2008 at 2:21 pm
Adam Bean (11/26/2008)
I am going to restore to a 2005 instance and try again to prove out that this is a 2000 problem.
Nope. It performs like a dog on SQL...
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 26, 2008 at 2:16 pm
shiva challa (11/24/2008)
With the (nolock) table hint, no shared locks are issued and exclusive locks are ignored.
Using nolock doesn't just allow dirty data. It essentially says to SQL that...
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 26, 2008 at 2:09 pm
Hmmm. Odd. Did you create that through the management studio GUI? If so, what options did you select?
What do the following return?
select name, type_desc from sys.objects
where object_id = OBJECT_ID('NAMES') 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 26, 2008 at 2:06 pm
Viewing 15 posts - 42,901 through 42,915 (of 49,552 total)