Forum Replies Created
Viewing 15 posts - 5,881 through 5,895 (of 59,070 total)
-
Reply To: Execution Log Clean Up
Jeffrey Williams wrote:The best I can find is that it is controlled by the service and not externally managed.
Either way, if I had this issue on my servers I would create...
-
Reply To: Extract data with variable column names and order
ScottPletcher wrote:The other disadvantages are the somewhat increased overhead and the possibility of increased and/or undetected errors. If you create a view, any error will be found immediately. If you...
-
Reply To: Perf hit for Increasing tran log frequency
To answer the question, you could instead change the criteria you cited to...
AND log_reuse_wait_desc <> Nothing'
Like I said in the comment in the code I posted, the...
-
Reply To: Execution Log Clean Up
Jeffrey Williams wrote:You cannot change the time when that process runs - but you can disable the process that removes log entries and perform that step manually.
Good info, Jeffrey. Just curious,...
-
Reply To: Creating indexes on a very large table takes over 5 hours
ScottPletcher wrote:The ORDER BY is useless (rather than "absolutely essential"). ORDER BY doesn't control the order of physical INSERTs into a table, only the assignment of identity values. I've quoted...
-
Reply To: Extract data with variable column names and order
Just checking so correct me if I'm wrong, please... The end result of your code was to build a view for each AttributeType and then something would have to figure...
-
Reply To: An Alternative (Better?) Method to UNPIVOT (SQL Spackle)
Damn... It's been 5 years already. I miss you buddy!
-
Reply To: An Alternative (Better?) Method to UNPIVOT (SQL Spackle)
taylor_benjamin wrote:I have been demonstrating how to create high performance Pivot transformations of data using SQL or Linq. Those queries both use a Pivot Table to enhance the performance of...
-
Reply To: Are the posted questions getting worse?
Having a bit of a tough time yesterday and today remembering a good long distance friend and SQL heavy hitter. It's hard to believe that it's been 5 years already. ...
-
Reply To: Extract data with variable column names and order
ScottPletcher wrote:Btw, how then do you exec the code the function created? Wouldn't you some type of loop / cursor to do that anyway?
Based on the original request, I assumed...
-
Reply To: reference for writing stored procedures (especially spatial) in DB2
Ah, gotcha. I found the following in another search. Will this help?
-
Reply To: Subtract running amount
Heh... this is why us old dinosaurs rock...
Someone else: "Hey there, Grandpa! Can you tell us that old story about what it was like to calculate running totals in the...
-
Reply To: Subtract running amount
Steve Collins wrote:I did find some old documentation for SQL Server 2005 which says the SUM function may be followed by the OVER clause.
Yep... and I didn't contradict. Go...
-
Reply To: reference for writing stored procedures (especially spatial) in DB2
I'll suggest the following search...
https://www.google.com/search?create+a+stored+procedure+in+DB2
Viewing 15 posts - 5,881 through 5,895 (of 59,070 total)