Viewing 15 posts - 26,071 through 26,085 (of 49,552 total)
Profiler filters are a pain to work with. Profiler does the opposite with nulls that SQL does.
Import into a table and query. Far, far easier.
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 16, 2011 at 11:45 pm
sysobjects and syscomments are deprecated, are included only for backward compatibility, will be removed in a future version of SQL and should not be used any longer.
Use sys.objects and sys.sql_modules...
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 16, 2011 at 11:35 pm
sqlbuddy123 (5/16/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 16, 2011 at 11:18 pm
WayneS (5/16/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 16, 2011 at 2:02 pm
Grant Fritchey (5/16/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 16, 2011 at 1:56 pm
From a query, not the GUI
DROP DATABASE <dbname>
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 16, 2011 at 1:29 pm
What you did there is the absolute last resort for suspect databases, not the first thing you should do. You may well have messed things up worse.
SQL error log. There...
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 16, 2011 at 1:28 pm
Restart SQL. No need to do anything else, the transaction will finish rolling back during crash recovery (it's just kinda stuck, probably waiting for something it will never get), DB...
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 16, 2011 at 1:27 pm
Max memory set the limit to the buffer pool. SQL does also allocate memory outside the buffer pool - the non-paged memory - for things like thread stacks, backup buffers,...
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 16, 2011 at 1:25 pm
Jason Shadonix (5/16/2011)
jmerrill 28016 (5/16/2011)
Other than the fact that it was an advertisement for a commercial product, what was particularly incorrect on the page you referenced?
Advertising aside, isn't it pretty...
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 16, 2011 at 12:36 pm
jmerrill 28016 (5/16/2011)
Other than the fact that it was an advertisement for a commercial product, what was particularly incorrect on the page you referenced?
At this point I have neither 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
May 16, 2011 at 12:33 pm
There's barely a snowball's chance in hell you'll be able to get data back by reverse-engineering the front end. Column names, maybe (depends how the app queried the DB). Column...
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 16, 2011 at 12:16 pm
Kinda, but not a warning. Statement-terminating error (as opposed to batch-terminating or connection-terminating)
What you're seeing there is pretty much what the default behaviour without a try-catch is. Don't roll transactions...
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 16, 2011 at 12:14 pm
Good luck with that. Reverse-engineering a DB is an incredibly hard thing to do. You may be able to get the table names from the front end, unlikely to get...
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 16, 2011 at 11:55 am
Unless XactAbort is on, pretty much any non-fatal error will do that (pk violation, data type conversion, constraint violations, etc)
Interestingly enough, I have a blog post on this being published...
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 16, 2011 at 11:53 am
Viewing 15 posts - 26,071 through 26,085 (of 49,552 total)