Viewing 15 posts - 3,601 through 3,615 (of 49,571 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...
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/
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...
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...
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...
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...
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...
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
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...
February 14, 2016 at 1:27 am
Everything listed in this thread (other than the two tools Ed mentioned) are free.
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...
February 14, 2016 at 1:24 am
GilaMonster (2/12/2016)
Table definitions, index definitions, function definitionsand execution planplease.
February 12, 2016 at 7:25 am
Table definitions, index definitions, function definitions and execution plan please.
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...
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...
February 12, 2016 at 2:33 am
Viewing 15 posts - 3,601 through 3,615 (of 49,571 total)