Viewing 15 posts - 28,096 through 28,110 (of 49,552 total)
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
January 27, 2011 at 2:02 pm
They're not latches, but similar kind of idea, protection of shared resources. As I said, very very little info available as they're internal structures. None of the internals/troubleshooting books I...
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
January 27, 2011 at 2:02 pm
soj2008 (1/27/2011)
1.Properties window of the DataBase2."Option" tab.
3.Set "Recovery Model" to "Simple".;-)
And say goodbye to the ability to restore to point of failure, or any other time than the last full...
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
January 27, 2011 at 1:54 pm
Please post the stored procedure, the table definitions and the actual execution plan. See http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
January 27, 2011 at 1:44 pm
Well, you asked what a semaphore is and the very first link that the search returns is the wikipedia article on semaphores in computing. So, do you understand what 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
January 27, 2011 at 1:38 pm
http://www.google.com/search?q=what+is+a+semaphore
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
January 27, 2011 at 12:57 pm
reder (1/27/2011)
I was told to use the "nolock" to prevent a data lock.. ?? So far it has not been a problem with the other stored procs.
Yet.
See -...
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
January 27, 2011 at 12:53 pm
Ok, so what doesn't work? Where is the @CaseNbr parameter used?
btw, why Nolock? Is potentially inaccurate data acceptable?
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
January 27, 2011 at 12:37 pm
SKYBVI (1/27/2011)
actaully i was doing it on hte local machine, so no SP issue.
You mean you don't apply service packs to the local machine? Do you like running into...
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
January 27, 2011 at 12:24 pm
I think it's the ELSE portion that we need to see.
You're going to need to split that into a temp table or using a split function in order to use...
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
January 27, 2011 at 12:23 pm
Yes, you will. I was just pointing out a logic error.
Run profiler and see what SSRS is sending to 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
January 27, 2011 at 12:02 pm
1) You don't do = or <> checks with NULL. Do IS NULL or IS NOT NULL
2) http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/
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
January 27, 2011 at 11:52 am
YSLGuru (1/27/2011)
Maybe I missed something but Defaults don't work even for Updates if the INSERT does not list that field in its INSERT, isn't that right?
Defaults never work...
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
January 27, 2011 at 11:45 am
qur7 (1/27/2011)
increasing the Tempdb files are a way to clear the alert that tempdb is filling up.
No need, just increase the size of the file. That's just saying that 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
January 27, 2011 at 11:15 am
You will NOT find it in Visual studio 9 or 10. BIDs 2005 links with Visual Studio 8. Not any other version of visual studio.
Try what Ninja recommends
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
January 27, 2011 at 10:59 am
Viewing 15 posts - 28,096 through 28,110 (of 49,552 total)