Viewing 15 posts - 47,581 through 47,595 (of 49,552 total)
David Lester (1/25/2008)
Before I started working here, it never crossed my mind that being "invaluable" to a job was a bad thing.
That's one thing I learnt years ago. Becoming invaluable...
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, 2008 at 5:45 am
Could you please post table schema, sample data and desired results.
Please see the following article - http://www.sqlservercentral.com/articles/Best+Practices/61537/
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, 2008 at 5:02 am
Almost. I would suggest you leave the datetime as a datetime in SQL. That way you can use all the date time functions and you don't need to worry about...
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, 2008 at 5:01 am
In that case, I would suggest the following.
When the new file is spotted, import that file (bcp or Bulk insert) into a staging table. Then do joins between that staging...
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, 2008 at 2:54 am
In SQL a short date time is a date and a time. SQL tables have no concept of formats.
My access is rather rusty, but maybe you could link the 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 27, 2008 at 2:40 am
Cross post. Replies to the following thread please - Managing Hours and minutes (MS 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
January 27, 2008 at 2:38 am
Don't think so. Will check next week.
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 26, 2008 at 11:38 am
That's gonna really hurt, especially if there's no index. Are there other indexes on the table, other than the primary key? If so, on what columns
Where are you getting 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 26, 2008 at 11:34 am
The Insert into ... select is what you need. There's no problems with including variables or constants in the select clause of a select statement.
Insert into TheTBL (ColumnList)
SELECT M.Email, @msg...
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 26, 2008 at 11:29 am
virgilash (1/25/2008)
Ofcourse it is .. otherwise I would be fired ... 🙂
Had to ask. You'll be amazed how often the simplest possible explanation to a problem is the correct one....
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 25, 2008 at 2:00 pm
If you add all the columns listed in the group by to the select, what's the result set?
Basically, there's something in the group by that shouldn't be there for 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 25, 2008 at 1:57 pm
Which book is that? Author?
I had a book for (I think 441) that was so packed with errors it was worse than useless. Can't remember the title right now. 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
January 25, 2008 at 1:55 pm
How many non-leaf pages are there in the index? I think one of the index DMVs will show you that
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 25, 2008 at 9:03 am
virgilash (1/25/2008)
I'm trying to get the exec plan in xml format
Not on SQL 2000. The exec plan in xml is a 2005 specific feature (specific to the 2005 server,...
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 25, 2008 at 8:53 am
Do you have replication running (transactional or merge?) Full backups never truncate the transaction logs. Only log backups truncate the inactive portion of the log.
What are you checking to 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 25, 2008 at 8:50 am
Viewing 15 posts - 47,581 through 47,595 (of 49,552 total)