Viewing 15 posts - 511 through 525 (of 1,583 total)
I'm certain there's better ways to do this but I'd recommend creating a function that can be called as needed - this may help:CREATE FUNCTION [dbo].[fx_SplitColumnText](
@String varchar(50),
@Delimiter varchar(5),
@Side int
) RETURNS...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 12, 2014 at 8:05 am
Some links:
http://www.sqlservercentral.com/Forums/Topic1220236-1550-1.aspx
http://thefirstsql.com/2012/05/29/updated-create-point-in-time-restore-script-automatically/
http://technet.microsoft.com/en-us/library/ms179451.aspx
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 12, 2014 at 7:54 am
There could be a lot going on...If WRITELOG is your top metric here, I'd have to ask if all your log files from these busy DBs are all writing to...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 12, 2014 at 7:47 am
I'd create a little scalar function, should work like a charm:
CREATE FUNCTION [dbo].[fx_RemoveCharsFromString] (
@String nvarchar(max),
@Match varchar(255)
)
/*
----------------------------------------------------------------------------------------------------------------
Purpose: Removes unwanted...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 12, 2014 at 7:35 am
brianpaulflynn (2/11/2014)
Does SQL Diagnostic Manager allow you to continue browsing data collected from a server you no longer monitor?
Does anyone know if other DB monitoring products that...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 11, 2014 at 7:01 pm
Please post the TSQL for the jobs steps, as HanShi has mentioned, it could very well be related to an "external" process like xp_cmdshell, an executeable, etc.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 10, 2014 at 6:44 pm
Note: I threw that code together as a quick example only and most like will need tweaking so I don't advise running it "as-is" without verifying it beforehand
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 10, 2014 at 2:06 pm
Based upon your answers to Jeff's (excellent) questions, your first option sounds sufficient: Rename the table and move 1 month of data into the production table. Once complete. ...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 10, 2014 at 2:05 pm
You could merge Lowell's and Luis' suggestions together: use the OPENROWSET to bring everything into a temporary "staging" table, then select out the column names you want (in the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 10, 2014 at 12:24 pm
Of course, you make valid points - 😉 I originally suggested SSIS, but provided a TSQL alternative - not pretty, but there it is...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 10, 2014 at 11:42 am
@SQLRNNR - I agree with you 100% - I didn't say it wouldn't - I was saying it would not force new execution plans to be created.
I was answering the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 10, 2014 at 10:29 am
To clarify, are the columns the same, just in a different order daily? ie. (Fname, DOB, City, State, ZIP) and then possible (State, Zip, Fname, City, DOB) the next? ...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 10, 2014 at 10:23 am
Shrinking a database wouldn't cause the creation of any new execution plans.
Yes, this will cause your log file(s) to fill/grow (especially so with the index maintenance)
If space isn't...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 10, 2014 at 10:19 am
Eugene, you are quite right and I completely forgot about that. In this case, the OP should just create a physical table and select the results from that (then...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 10, 2014 at 10:00 am
Silly question, but did you check the C:\ on the computer you ran this from or on the server it is executing against?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 10, 2014 at 8:36 am
Viewing 15 posts - 511 through 525 (of 1,583 total)