Viewing 15 posts - 42,031 through 42,045 (of 49,552 total)
WayneS (1/1/2009)
Just prior to the full backup, we run a "backup log with no_log", followed by a "dbcc shrinkfile" on the database log file to shrink it to 50mb.
Why? If...
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 1, 2009 at 11:32 am
Mark (1/1/2009)
The problem I have with his solution is that he has a predefined set. No one has a predefined set of data in the real world.
That'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
January 1, 2009 at 11:31 am
I'll check the exec plan when I get SQL reinstalled. In the meantime, what's the definition of fnGetTerrTree, and can you post the schemas of the tables (as create table...
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 1, 2009 at 11:24 am
Please post table structure (as create table statements), some sample data and your expected results. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Do 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
January 1, 2009 at 5:57 am
What are the queries associated?
DBID 32757 is the resource database, where all the system views, functions and procedures are stored. So if the queries that you see are system procs,...
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 1, 2009 at 5:38 am
The tran log's not encrypted, but it's not designed to be human-readable. As far as I know, there are no official documents that are publicly released describing the data 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
January 1, 2009 at 5:35 am
RBarryYoung (12/31/2008)
The irony of course is that if SUM(..) OVER(..) allowed ORDER BY, 2/3rds of the uses for it (the Update pseudo-cursor) would disappear.
Apparently (and this is not confirmed), that'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
January 1, 2009 at 5:15 am
homebrew01 (12/31/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
December 31, 2008 at 8:27 am
bhimrajg (12/31/2008)
Ok....Here is simple query :
Is that the select inside one of the udfs?
What about the other udf?
And Please check the execution plan
Right click the exec plan, select save...
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
December 31, 2008 at 8:20 am
Perry Whittle (12/31/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
December 31, 2008 at 8:08 am
bhimrajg (12/31/2008)
I have uploded the execution plan below
You can zip it and attach it to your post here.
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
December 31, 2008 at 8:01 am
Please post the code for the UDFs, the schema of the tables involved, and the indexes on them.
Oh, and read these two posts as well.
http://sqlinthewild.co.za/index.php/2008/08/12/views-or-functions/
http://scarydba.wordpress.com/2008/08/15/more-on-table-valued-functions/
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
December 31, 2008 at 7:59 am
Mani (12/31/2008)
after immediately 3 weeks got one more problem that i posted today..and we are decided to take experts opinion before directly contacting to Microsoft support as it is not...
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
December 31, 2008 at 7:59 am
MANU (12/31/2008)
4.) Rebuild the database log file:dbcc rebuild_log ('dblogfilename','C:\Program Files\Microsoft SQL
Server\MSSQL\Data\ myDatabaseName2_log.LDF')
That should be the absolute last resort when all else has failed, not the first thing to try. Rebuilding...
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
December 31, 2008 at 7:48 am
Christopher Stobbs (12/31/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
December 31, 2008 at 7:45 am
Viewing 15 posts - 42,031 through 42,045 (of 49,552 total)