network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 2 years, 7 months |
| seen | Feb 5 '12 at 18:20 | |
| stats | profile views | 4 |
|
Oct 12 |
comment |
SQL server 2005 Slow access @Seb You have to run the trace yourself. You can start one by going to Tools > SQL Server Profiler. I like the TSQL template personally. And by 30 people, do you mean 30 concurrent connections? |
|
Oct 9 |
comment |
How to protect file if physicall access to the server is possible? W2008R2 As an aside, if you don't trust your colocation company, I'd suggest shopping for a different one. |
|
Oct 9 |
answered | How to protect file if physicall access to the server is possible? W2008R2 |
|
Oct 4 |
comment |
SQL server 2005 Slow access Also, how much memory is being paged to disk? How many processor cores do you have? How many people are trying to run queries concurrently? |
|
Oct 4 |
comment |
SQL server 2005 Slow access You might want to consider running a SQL Profiler trace report. I suspect your users are running a query that is very disk-intensive or has many CTE's (Common Table Expressions) that require full completion before the rest of the query is executed. You could also use the "Display Estimated Execution Plan" button on their queries yourself to see where the most expensive part of the query is. |
|
Dec 14 |
comment |
Using downloaded microsoft xp updates on multiple computers Off the top of my head, I don't remember where Windows stores downloaded updates from Windows Update. I was actually referring to downloading them manually from Microsoft.com (Which is what Joe also said). Nonetheless, this sounds like a giant pita... |
|
Dec 14 |
answered | Using downloaded microsoft xp updates on multiple computers |
|
Nov 1 |
comment |
given a URL, how do I find the domain registrar and the web host? You can run tracert from a Windows Command Prompt. The Command Prompt is accessed by Start > Run > cmd.exe |
|
Oct 26 |
answered | Best/Cheapest way to buy five microsoft office licences (2010 ed.)s |
|
Oct 7 |
awarded | Teacher |
|
Oct 7 |
answered | what is “show execution plan” in sql server? |
