Viewing 15 posts - 3,601 through 3,615 (of 49,552 total)
SQL!$@w$0ME (2/15/2016)
But in this case the locked pages in memory is enabled.
Yes, exactly. And because it's enabled Task Manager is reading far, far lower than it should be and giving...
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
February 15, 2016 at 9:36 am
Don't use Task Manager to track SQL's memory. It lies!
http://sqlinthewild.co.za/index.php/2016/01/19/stop-using-task-manager-to-check-sqls-memory-usage/
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
February 15, 2016 at 9:22 am
If the login has Policy on, then SQL uses the password policy from Active Directory, from the domain if the SQL instance is installed on a domain member, from the...
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
February 15, 2016 at 8:58 am
jasona.work (2/15/2016)
How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses it was the solution?
Shocked that someone...
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
February 15, 2016 at 7:35 am
No, the SQL Server being clustered is not the problem.
A timeout occurs when a query/stored procedure call takes longer than the command timeout is set to, and so the application...
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
February 15, 2016 at 7:19 am
There's no error in the log, because it's not a SQL error. A timeout is a client-side error. The client decides that it's waited too long for the query 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
February 15, 2016 at 2:58 am
Look at something like Microsoft DocumentDB. It's an online service (like Azure SQL DB, but a document database), not a product that has to be purchased, servers provisioned for and...
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
February 14, 2016 at 10:32 am
GilaMonster (2/14/2016)
What exactly are you trying to do? Post table definitions (as CREATE TABLE statements) and sample data (as INSERT statements) please
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
February 14, 2016 at 9:30 am
Err... Seek and scan are SQL's two internal operations for accessing indexes, they're not something you explicitly use.
What exactly are you trying to do? Post table definitions (as CREATE 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
February 14, 2016 at 1:27 am
Everything listed in this thread (other than the two tools Ed mentioned) are 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
February 14, 2016 at 1:25 am
manub22 (2/13/2016)
On running the mentioned statement in one of previous responses, the database came back to normal:ALTER DATABASE dbXYZ SET ONLINE WITH ROLLBACK IMMEDIATE
That only works after whatever caused the...
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
February 14, 2016 at 1:24 am
GilaMonster (2/12/2016)
Table definitions, index definitions, function definitionsand execution planplease.
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
February 12, 2016 at 7:25 am
Table definitions, index definitions, function definitions and execution plan please.
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
February 12, 2016 at 5:57 am
PiMané (2/12/2016)
1. DEFRAG/REBUILD INDEXES- Can create a maintenance task on SQL Server (it does this out of the box)
Please don't. The maintenance task is braindead. Use Ola's scripts, use Minion...
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
February 12, 2016 at 4:54 am
It's fairly rare to find an entry level DB position. Most people who got into the DB area did so from another IT position. Helpdesk or developer, maybe with your...
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
February 12, 2016 at 2:33 am
Viewing 15 posts - 3,601 through 3,615 (of 49,552 total)