Viewing 15 posts - 5,671 through 5,685 (of 49,552 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,...
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
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...
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
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.
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
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...
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
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...
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
June 5, 2015 at 4:45 am
Make it a separate table and join them in your queries.
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
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...
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
June 5, 2015 at 2:56 am
ioana-477197 (6/5/2015)
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
June 5, 2015 at 2:55 am
CAST(<source column>) as NVarchar(1))
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
June 5, 2015 at 2:43 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...
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
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...
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
June 4, 2015 at 1:21 pm
ChrisM@Work (6/4/2015)
spectra (6/4/2015)
My query...
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
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...
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
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...
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
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
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
June 4, 2015 at 12:42 pm
Viewing 15 posts - 5,671 through 5,685 (of 49,552 total)