Viewing 15 posts - 44,026 through 44,040 (of 49,552 total)
Why the cursor? That whole thing could be replaced by a single statement.
select CONVERT(datetime, FechaRecepcion, 103)
from Ejemplares
where ISDATE(FechaRecepcion) = 1
The reason for what you're getting though is that the cursor...
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
October 3, 2008 at 2:09 pm
rbarryyoung (10/3/2008)
GilaMonster (10/3/2008)
That looks like the estimated plan. Is there any possibility of seeing the actual plan please?
Probably not from the production environment in the time that I have left...
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
October 3, 2008 at 2:02 pm
No. The declared order of columns has no effect on anything other than the order they're returned in a select * query. The order defined doesn't even define the physical...
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
October 3, 2008 at 1:02 pm
That looks like the estimated plan. Is there any possibility of seeing the actual plan please?
The only parameter I can see in there is @collectionGuid. Will vastly different numbers of...
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
October 3, 2008 at 12:57 pm
binaryspiral (10/3/2008)
Quick Question: If you don't have Enterprise Manager, how do you work with your databases?
SQL Server Management Studio. I only have SQL 2005 and 2008 instances. Enterprise manager 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
October 3, 2008 at 12:50 pm
Odd. While I had the exam crash and restart, it wasn't slow at all. At most a couple secs between questions.
I'm writing 71-433 next week. Will see if it'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
October 3, 2008 at 11:22 am
If that is your log file, then I would hazard a guess that your DB is in full recovery model and you have no log backups.
Read this - http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/
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
October 3, 2008 at 11:17 am
the 'fullname', if you will, of each primary key is the name of the table plus the column name.
The name of the primary key is whatever you specify it 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
October 3, 2008 at 11:17 am
As far as I'm aware, the support policy for SQL in a virtual environment is still as documented in the following kb article
http://support.microsoft.com/kb/897615
I know SQL 2008 is fully supported on...
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
October 3, 2008 at 11:15 am
chakri002 (10/3/2008)
Use Instead of Triggers on the Views to Delete or Update Records directly from the view.
You did notice that the thread you answered was 2 years old?
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
October 3, 2008 at 11:06 am
carlos.tapadinhas (10/3/2008)
Hi again,How can i know which tables are created on tempdb and aren't used anymore, in sysobjects?
Answered here:
http://www.sqlservercentral.com/Forums/Topic580338-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
October 3, 2008 at 11:05 am
Temp tables will be automatically dropped when the connection that created them is closed. You don't have to (and in fact can't) manage the tables in TempDB directly.
2005 does cache...
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
October 3, 2008 at 11:03 am
There's no direct equivalent. SQL doesn't have the concept of a row's position in the table.
You can use row_number(), but you need to specify the ordering for the allocation of...
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
October 3, 2008 at 10:59 am
This one's pretty good. Read the comments on the blog post too, as the function needs a table creating.
http://philcart.blogspot.com/2007/06/split-function.html
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
October 3, 2008 at 10:55 am
I would imagine so. It's a cached plan with parameters, not much different from a stored proc.
Fixes would be the same as for a stored proc, use variables instead of...
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
October 3, 2008 at 10:52 am
Viewing 15 posts - 44,026 through 44,040 (of 49,552 total)