Viewing 15 posts - 26,251 through 26,265 (of 49,552 total)
daquere (5/9/2011)
he type of column "empresa" is integer, if the column type was varchar, would be better?
No. If it's numeric data then it should be an integer data type. Changing...
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 9, 2011 at 3:50 am
That can be any LSN in the interval covered by that log backup. You can use RESTORE HEADERONLY to see the LSN range that a log backup covers.
That's a very...
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 9, 2011 at 2:19 am
pkaursikhni (5/9/2011)
declare @dir varchar
SET @dir = 4, 2
SELECT *, empresa FROM DIRETORIAS WHERE (empresa IN (@dir))
Note :...
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 9, 2011 at 2:17 am
Those aren't instead of Inner/Outer, they are used as well as inner/outer.
They're query hints, used to force the optimiser to use a particular join type. Shouldn't in general be used...
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 9, 2011 at 2:14 am
Rin Sitah (5/9/2011)
Does this memory get released when its not being used any more?
Only if the OS requests that SQL release memory AFAIR.
Will this continue to grow until it...
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 9, 2011 at 2:10 am
In your first post you said 'database shrink', not log file shrink. Hence the comments on fragmentation
Shrinking the log is still a bad idea, for different reasons. Growing the log...
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 9, 2011 at 2:02 am
free_mascot (5/9/2011)
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 9, 2011 at 2:02 am
Two steps back...
You have an index rebuild followed by a database shrink? What a waste of time.
The shrink will fragment the indexes more than they were before the rebuild happened....
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 8, 2011 at 11:35 pm
You're not being clear. A point-in-time restore can be done to any point (time or LSN) that's covered by your log backups
What exactly do you want? Explain in detail
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 8, 2011 at 11:34 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1105170-391-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
May 8, 2011 at 11:22 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1105182-147-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
May 8, 2011 at 11:22 pm
WayneS (5/8/2011)
Look up sp_executesql in Books-Online
Or search for a split function on this website. Safer than dynamic SQL (because of SQL Injection and the permission requirements of dynamic SQL)
I don'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 8, 2011 at 11:20 pm
Regarding indexes and ORs... http://sqlinthewild.co.za/index.php/2011/05/03/indexing-for-ors/
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 8, 2011 at 12:12 pm
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 8, 2011 at 11:19 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1105123-149-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
May 8, 2011 at 9:46 am
Viewing 15 posts - 26,251 through 26,265 (of 49,552 total)