Viewing 15 posts - 41,566 through 41,580 (of 49,552 total)
That'll happen any time an insert doesn't succeed (due to a constraint violation, a datatype conversion error or a trigger rollback) or when rows are deleted. The id will be...
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 19, 2009 at 10:02 am
shakir (1/19/2009)
Please give me detail solutions.....
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
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 19, 2009 at 9:39 am
Jason Manthei (1/19/2009)
Hello,I have 1 database on my server that the recovery model is automatically changing from full to simple making my transaction log backup routines fail.
SQL will not automatically...
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 19, 2009 at 9:38 am
krypto69 (1/19/2009)
Like this Gail?
Exactly.
Would you mind editing your earlier post to do the same? It's nothing to do with the data or values, it's just to prevent the large...
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 19, 2009 at 9:22 am
Sure. Have you looked in the articles section of this website?
You can read through this - Managing Transaction Logs[/url] and this http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx
And if you're still unsure, ask.
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 19, 2009 at 8:27 am
In addition, if this is ASP.Net coding, you'll probably get a much better response on an ASP.Net site (maybe the microsoft forums - http://social.msdn.microsoft.com/Forums/).
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 19, 2009 at 7:51 am
Jack Corbett (1/19/2009)
That's probably my favorite feature of the google toolbar, spell checking just like in Word.
Firefox has that built in. Why do you think I make so few spelling...
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 19, 2009 at 7:28 am
andy.brown (1/19/2009)
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 19, 2009 at 7:23 am
Please post in the appropriate forum in the future and not just anywhere you feel like.
Why do you want to shrink? Databases tend to grow as more data gets put...
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 19, 2009 at 5:17 am
Please post table definitions, index definitions and execution plan (saved as a .sqlplan file, zipped and attached)
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 19, 2009 at 5:15 am
Please post in the appropriate forum in the future and not just anywhere you feel like.
That's no a deadlock. A deadlock is when two or more processes have two or...
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 19, 2009 at 5:14 am
nashreen.mosaheb (1/19/2009)
I know its vulnerable .. can a virus be the cause?
Maybe. I've seen malware that uses SQL injection. It's not the first place I'd look, but it is...
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 19, 2009 at 4:57 am
Which line's the error 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
January 19, 2009 at 4:29 am
Please post SQL 2000-related questions in the SQL 2000 forums. If you post in the 2005 forums, you're very likely to get 2005-specific solutions.
Can you explain more what you're trying...
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 19, 2009 at 4:25 am
nashreen.mosaheb (1/19/2009)
I don't think of SQL injection attack... as the users are not into this well.
You'll be surprised. It's a web app and you're using inline SQL. You are...
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 19, 2009 at 4:24 am
Viewing 15 posts - 41,566 through 41,580 (of 49,552 total)