Viewing 15 posts - 181 through 195 (of 476 total)
Lowell (10/5/2015)
they added code that insta-deletes anything Celko posts
Still dates the thread though, so I visit the thread trying to work out what has changed. Clearly no new post ......
October 12, 2015 at 5:55 am
ben.brugman (10/12/2015)
Maybe some type of cooperation would be possible.Any takers?
I'd be up for that 🙂
I suppose the key elements are:
See if matching Table / View / SProc exists
If not ,...
October 12, 2015 at 5:27 am
vmit02 (10/11/2015)
The backups are occurring every 15 minutes but note that the last two listed have a gap in the LSNs even though they are consecutive backups.
Someone / something else...
October 12, 2015 at 3:06 am
drew.allen (10/9/2015)
October 9, 2015 at 10:29 am
Personally I'm not keen on that sort of workaround (or the "-1" for the EmpLogin for that matter) such things tend to have side effects and/or break sooner or later...
October 9, 2015 at 9:01 am
Eric M Russell (10/9/2015)
Stuff like aliasing column names and stripping quotes from column values can be easily handled within the view or stored procedure, from which BCP exports.
Yeah, but you've...
October 9, 2015 at 8:41 am
ben.brugman (10/9/2015)
I am interessested in X, is the script for this available?
Sorry, because it, currently, relies on Metadata tables specific to our APPs it won't work standalone.
I should try to...
October 9, 2015 at 8:12 am
Assuming the "Please select" needs to be the first entry? then the ORDER BY needs to perhaps be:
ORDER BY
CASE WHEN EmpLogin = '-1' THEN 1...
October 9, 2015 at 3:55 am
I have an SProc that I use for this purpose. It has a short name - one character would do 😉 - and takes partial names for tables etc....
October 9, 2015 at 3:44 am
GilaMonster (10/9/2015)
October 9, 2015 at 3:28 am
Good point Gail, thanks. When we do this we do so that we can just use ORDER BY MyID in other queries to avoid having to store all the...
October 9, 2015 at 3:26 am
Our routines which delete large amounts of data do the following:
For all records to be delete get the Clustered Index keys into #TEMP table, ordered by clustered index and containing...
October 9, 2015 at 3:22 am
Dunno if relevant, but just in case ...
We have to "export" a CSV list of various mail-lists (i.e. filtered on various categories) to a Bulk Email service each night.
We have...
October 9, 2015 at 3:14 am
I don't think that backwards compatibility for SQL 2000 is still supported. So it might be that your code behaves "differently" in some subtle way with a newer version....
October 9, 2015 at 3:01 am
I'm sure you know this, but in case not: you can add an IDENTITY to a SELECT ... INTO #TempTable :
SELECT
[highlight="#ffff11"]MyID = IDENTITY(int, 1, 1),[/highlight]
EmpLogin,
AttorneyName = LastName + ', '...
October 9, 2015 at 2:49 am
Viewing 15 posts - 181 through 195 (of 476 total)