Viewing 15 posts - 45,061 through 45,075 (of 49,552 total)
Please don't cross post. It just wastes people's time and fragments replies. Many of us read all the forums.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic552520-146-1.aspx
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
August 14, 2008 at 5:17 am
My guess, there are too many rows returned for the index seek + bookmark lookup to be efficient, so unless the index is covering, SQL elects to scan the cluster.
Check...
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
August 14, 2008 at 4:55 am
Brandie Tarvin (8/14/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
August 14, 2008 at 4:41 am
bodhilove (8/14/2008)
why is the max set so high as a default (2147483647 MB)? If I am getting paging problem would that be because this is too high?
The default basically means...
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
August 14, 2008 at 4:36 am
Ratheesh.K.Nair (8/14/2008)
The application is showing disk full error.
That's not a permission-related error. If you could post the exact error message, we could probably tell you whether or not it's 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
August 14, 2008 at 4:32 am
Depends on your table structure and what and who you need to mail. Put into the temp table enough info that you can then identify which salaries you updated 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
August 14, 2008 at 2:51 am
vrijesh prajapati (8/14/2008)
HI, SQL 2005 DATABSE(SP4) SERVER IS GENERATING HUGE BROADCAST & OUR ROUTERS WERE GETTING HANGED.
First thing, please double check your version. SQL Server 2000 is up to service...
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
August 14, 2008 at 2:25 am
bhuvnesh.dogra (8/14/2008)
Executed as user: DOMAIN\SQLMan. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [SQLSTATE 28000] (Error 18456). The step...
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
August 14, 2008 at 2:12 am
Perhaps write a stored procedure, keep track of the employees that you've updated in a temp table and then send the mail at the end of the procedure.
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
August 14, 2008 at 1:58 am
It would help if you said what error they were getting.
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
August 14, 2008 at 1:52 am
Sure. Untested, but this should give you an idea.
UPDATE SomeTable
SET RMFP = CASE uid WHEN 1 THEN 15 WHEN 7 THEN 18 WHEN 8 THEN 19 ELSE 0...
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
August 14, 2008 at 1:51 am
Triggers fire after every update. That's how they work. You can put code into the triggers so that they don't do whatever they do in certain cses, but that's all.
Perhaps...
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
August 14, 2008 at 1:35 am
Do we get a prize for answering correctly?
Remember that "_" is a single character wildcard in SQL, like "?" is in access.
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
August 14, 2008 at 1:30 am
Ratheesh.K.Nair (8/13/2008)
CAn anyone please explain what is -c and -f ???
Look in Books online under the section "Using the SQL Server Service Startup Options". It lists all of the command...
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
August 14, 2008 at 1:29 am
bhuvnesh.dogra (8/14/2008)
Dude please tel how to do it
I did.
Create a SQL login on that server.
Give that login just the rights that it needs for what you are doing...
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
August 14, 2008 at 1:28 am
Viewing 15 posts - 45,061 through 45,075 (of 49,552 total)