Viewing 15 posts - 21,211 through 21,225 (of 49,552 total)
Query the trace from SQL (fn_trace_gettable) then export as a .csv
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 9, 2012 at 8:54 am
There's still a question? Thought from your comment you were happy.
Want anything useful? Post actual execution plans and queries and table designs. (p.s. you have huge tables, don't expect instant...
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 9, 2012 at 8:52 am
If you do you'll have to rebuild all your indexes afterwards (and that's not trivial on a huge DB). Try a shrink with truncate_only first, see if that has enough...
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 9, 2012 at 8:51 am
Roy Ernest (1/9/2012)
I see lots of comments regarding post counts... Does everybody have a target?
No, no targets here (though I'll take a screenshot of max_smallint when that happens)
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 9, 2012 at 8:40 am
You're probably OK unless you're dropping thousands of tables or really, really, really huge ones. Table drops just log the deallocation of pages (and the required modifications to the system...
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 9, 2012 at 8:21 am
syscolumns is deprecated (has been since 2005) and should not be used in new development. Use sys.columns.
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 9, 2012 at 7:59 am
While that's listed as a seek (for the like), it's almost a full table scan. The predicate is Keyword > '-', which every single entry starting with A..Z, a..z, so...
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 9, 2012 at 7:58 am
No, you're not going to find database servers exposed and free on the internet.
If you want to play, you can install SQL Express on your local machine, it's free, but...
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 9, 2012 at 7:46 am
Please post table definitions, index definitions and execution plans of both of those queries, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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 9, 2012 at 7:39 am
Here you go. Very simple use of UNPIVOT.
SELECT Date ,
Person
FROM ( SELECT date ,
...
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 9, 2012 at 7:21 am
Unpivot switches the table around so that the column names become values, then you can filter.
If you need example code, then I need table definitions (create table...) and sample data...
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 9, 2012 at 7:13 am
You're looking for the UNPIVOT keyword, then a filter on the unpivoted results. Books Online has details on the unpivot syntax (it can be a little tricky)
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 9, 2012 at 6:48 am
If you open up Book Online (the SQL help file) there's a lot of info on the hardware requirements. If you have no idea where to start (as it sounds),...
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 9, 2012 at 6:33 am
SameerKKhan (1/9/2012)
thanks.but i dont have the backup....and the transaction is committed,....In this scenario is there a possibility of getting the data back????
Pretty much, no.
You could spend $1000+ on a...
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 9, 2012 at 6:29 am
Rollback will only work if you started an explicit transaction before the delete, and that transaction has not yet committed.
To get the data back, get your latest database backup,...
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 9, 2012 at 5:56 am
Viewing 15 posts - 21,211 through 21,225 (of 49,552 total)