Viewing 15 posts - 4,561 through 4,575 (of 49,552 total)
souLTower (10/9/2015)
Ah, so I should enter a real number. EX 2GB for OS, remainder for SQL?
GilaMonster (10/9/2015)
See Chapter 4: https://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ for guidance
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
October 9, 2015 at 7:02 am
souLTower (10/9/2015)
In SSMS under server properties we're using the default.
That's a problem. The default is 2000 TB. It's fine if the server has over 2000 TB of memory, but if...
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
October 9, 2015 at 6:48 am
jonathanm 4432 (10/9/2015)
-U sa -P netfinity
Please say that's not the real password...
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
October 9, 2015 at 6:25 am
Other than possibly a nonclustered index on B.NANUM, not really much you can do.
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
October 9, 2015 at 5:44 am
What do you mean, you've set SQL's memory to max?
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
October 9, 2015 at 5:30 am
One other thing Melanie, unless there's more to the code than you've shown, the temp table isn't needed at all. This should be more efficient
SELECT '-1' AS EmpLogin, 'Please Select'...
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
October 9, 2015 at 3:39 am
Kristen-173977 (10/9/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
October 9, 2015 at 3:34 am
Not a template, but...
Open Object explorer, navigate to a table/view, Drag the 'columns' folder to your query window.
SQLPrompt does all the column generation for inserts and selects. It's not free,...
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
October 9, 2015 at 3:08 am
Kristen-173977 (10/9/2015)
SELECT
[highlight="#ffff11"]MyID = IDENTITY(int, 1, 1),[/highlight]
EmpLogin,
AttorneyName = LastName + ',...
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
October 9, 2015 at 2:52 am
pietlinden (10/8/2015)
I would suggest downloading Ola Hallengren's scripts to manage backups so that your databases get backed up in case of disaster/data loss.
Ola's scripts create jobs, and Express does not...
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
October 9, 2015 at 2:39 am
Even in 2008, you could and would at some point get different ordering, since there was no order by on the outer select.
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
October 8, 2015 at 3:21 pm
http://www.red-gate.com/community/books/accidental-dba
It was written for 2008, so a little out of date, but still very good.
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
October 8, 2015 at 2:47 pm
That said, I suspect you left something out, as the original query, on SQL 2008 R2, returns
Msg 1033, Level 15, State 1, Line 15
The ORDER BY clause is invalid 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
October 8, 2015 at 2:44 pm
You have no order by on that original query, so SQL is under no obligation to return the data to you in any particular order. I suspect the QO is...
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
October 8, 2015 at 2:43 pm
Jack Corbett (10/8/2015)
WayneS (10/7/2015)
GilaMonster (10/6/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
October 8, 2015 at 2:21 pm
Viewing 15 posts - 4,561 through 4,575 (of 49,552 total)