Viewing 15 posts - 46,426 through 46,440 (of 49,552 total)
All instant file initialisation means is that the OS doesn't zero out the file during allocation. It means that the file can be allocated with just some changes to 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
May 22, 2008 at 11:52 am
It mainly depends on the queries that use that table.
There have been a couple discussions on this the last few weeks. These 2 threads should get you started. If 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
May 22, 2008 at 11:47 am
I assume you're using object explore or registered servers then. The step/start/restart there uses the currently logged in windows user and net commands to do the requested operation. It doesn'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
May 22, 2008 at 11:17 am
aspirant.dba (5/22/2008)
When i executed Select statement against the Table, it took more than 25 mins to return the table.
If you tried to retrieve the entire table it's going to...
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
May 22, 2008 at 11:13 am
Generally for access violations you should contact Microsoft's Customer Support Services (formerly known as PSS) as they have much more chance of solving this than we do. It does cost,...
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
May 22, 2008 at 10:58 am
How are you restarting the service? (registered servers, object explorer, xp_cmdshell, shutdown)?
The user which am using is a SQL login and its not a domain user.
I'm not talking about...
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
May 22, 2008 at 6:36 am
Ratheesh.K.Nair (5/22/2008)
I tried using a new login with only datareader and datawriter database roles and access to only one DB.
Not what I asked.
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
May 22, 2008 at 5:56 am
you can use exec, since you're not passing parameters in or out of the dynamic SQL
CREATE procedure Search
(
@SearchKeyword Varchar(2000),
@Productid varchar(2000),
@Type varchar(200),
@SQLPerms varchar(5000)
)
as
Declare @sql varchar(7000)
set @sql=' This Statement length goes...
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
May 22, 2008 at 5:50 am
How are you restarting it?
Are you a domain/local administrator on the server?
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
May 22, 2008 at 5:27 am
Please rather post SQL 7 related questions in the SQL 7 and 2000 forum, rather than the SQL 2005 forum. Here you're going to get a lot of suggestions 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
May 22, 2008 at 5:12 am
Sounds like you may have hit a bug.
What's your version, edition and OS? Can you zip and attach the text file that the dump creates to a post 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
May 22, 2008 at 12:24 am
Slawek (5/21/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
May 22, 2008 at 12:02 am
Matt Miller (5/21/2008)
If you want to see some REALLY interesting things - throw in the MAX() OVER () into your testing.
Max () OVER ()???? :blink:
< wanders off 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
May 21, 2008 at 2:49 pm
In SQL 2005, only objects that a user has rights on can be seen from the system views. So, if your web site user has no access to the base...
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
May 21, 2008 at 2:36 pm
You may be able to remove the inner cursor. The outer one, no.
WHILE @@FETCH_STATUS = 0
BEGIN
--Find the number of days before ESCALATION
...
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
May 21, 2008 at 2:00 pm
Viewing 15 posts - 46,426 through 46,440 (of 49,552 total)