Viewing 15 posts - 5,671 through 5,685 (of 49,571 total)
Figure out why the plans are different (probably has to do with data volume), then figure out if you really want production using the development plan (hint, you usually don't,...
June 6, 2015 at 6:23 am
At the end of your batch, run DROP TABLE, then you won't get an error when you create it at the beginning.
Or, comment out the CREATE TABLE and TRUNCATE TABLE...
June 6, 2015 at 6:19 am
Write queries efficiently, make sure that there are supporting indexes. That's mostly what it comes down to.
June 5, 2015 at 9:53 am
dwilliscp (6/5/2015)
UPDATEASETReserve_Pct = case when y.Reserve_Pct_Overwritten = 1
then y.[Reserve_Pct] else a.[Reserve_Pct] end
That will work fine.
The error was because you left in a column alias from when it was...
June 5, 2015 at 7:03 am
Chrille (6/5/2015)
I thought that by running DB1's nightly FULL backup in COPY-ONLY mode, it wouldn't interfere with our normal backup plans restore sequence.
Correct, it doesn't.
Well, more specifically it doesn't interfere...
June 5, 2015 at 4:45 am
Make it a separate table and join them in your queries.
June 5, 2015 at 3:31 am
GG_BI_GG (6/5/2015)
GilaMonster (6/5/2015)
CAST(<source column>) as NVarchar(1))CAST(('0' as franchiseevendaccount) as NVARCHAR(1))
---
Incorrect syntax near the keyword 'as'.
Well, yes that's going to give an error. Aliases go after the column definition, not in...
June 5, 2015 at 2:56 am
ioana-477197 (6/5/2015)
June 5, 2015 at 2:55 am
Jeff Moden (6/4/2015)
Opening a new thread probably won't change those facts. 😉
He posted a new thread, posted a query slightly different to the one here (with a few WHERE clause...
June 5, 2015 at 1:03 am
Ed Wagner (6/4/2015)
I think there's a fundamental lack of understanding and resistance to learning that I don't know if I can overcome.
He's borderline on my blacklist because of that. Feel...
June 4, 2015 at 1:21 pm
ChrisM@Work (6/4/2015)
spectra (6/4/2015)
My query...
June 4, 2015 at 12:51 pm
jwashburn 18707 (6/4/2015)
but the only likely result I see would be more page faults and heavier use of virtual memory but nothing that should adversely impact the users.
Errr, no.
SQL Server...
June 4, 2015 at 12:47 pm
sgmunson (6/4/2015)
I don't think SQL Express is by license, allowed to support multiple users, regardless of the MS Access intermediary...
You're thinking about MSDE, the free version of SQL 2000. Express...
June 4, 2015 at 12:44 pm
And, back on topic, can anyone help our poor, out-of-his-depth friend with locating a time machine?
http://www.sqlservercentral.com/Forums/Topic1691611-391-1.aspx
June 4, 2015 at 12:42 pm
Viewing 15 posts - 5,671 through 5,685 (of 49,571 total)