meta user
network profile
| bio | website | |
|---|---|---|
| location | Altanta Georgia | |
| age | 35 | |
| visits | member for | 5 months |
| seen | 15 hours ago | |
| stats | profile views | 39 |
I'm the Sql Server DBA for a "Top 300" US website. My areas of expertise are full-text search, sql internals, troubleshooting performance issues and scaling up. I'm passionate about Sql Server and I'm not scared of the debugger.
|
1d |
comment |
How would I change this relational model to fit a nosql database? I'd start with a 1-to-1 with what you have, and only try something different if you can show that it performs better. Also, due to the maximum size limit of a document in MongoDB you may be limiting yourself if you denormalize too extensively. |
|
1d |
answered | How would I change this relational model to fit a nosql database? |
|
1d |
answered | dimension table with “like” condition |
|
1d |
comment |
How would I change this relational model to fit a nosql database? Why are you switching from a known scaleable design that could easily handle 10's of thousands of queries per second (without sharding) and forcing it into a nosql solution? It is very unfortunate if it truly is "beyond your control". |
|
May 16 |
comment |
Can I use the database and query it while full-text indexing? for fulltext, no. All editions are online. however, you will get partial results while the index is being rebuilt. |
|
May 13 |
awarded | Caucus |
|
May 10 |
comment |
Concurrent Access causing deadlock on the same table Can you add the rest of the deadlock graph? Also, the select query wouldn't take any kind of "X" lock (X, IX, SIX) so the insert query is deadlocking on something besides the select. Ideally, turn on traceflag 1222 and capture the deadlock in the errorlog as it provides more detailed information. |
|
May 9 |
comment |
Connection pools being reset with Error: 18056, Severity: 20, State: 46. & Perfmon Counters not showing What kind of auth are you using? (Sql Logins, Kerberos, NTLM?) SELECT s.session_id, host_name, login_name, c.auth_scheme FROM sys.dm_Exec_connections c INNER JOIN sys.dm_exec_sessions s ON c.session_id = s.session_id |
|
May 9 |
comment |
Connection pools being reset with Error: 18056, Severity: 20, State: 46. & Perfmon Counters not showing What is the exact version of sql servet you are using? select @@version |
|
May 4 |
comment |
What is the optimal response time for file growth Just to clarify, instant file initialization only works for data files, the log file has to be zeroed out so it can't be instantly initialized. |
|
May 2 |
comment |
Is it possible to backup a database that is not ONLINE? What state was msdb in? Since backup history is recorded in msdb, i don't think you should take any backups if msdb wasn't online. Also, sql agent jobs are stored in msdb, so how were they running if msdb wasn't online? |
|
May 2 |
comment |
Force sql server to run query conditions as written? Yes, it will run as written. It doesn't change the order per se, it eliminates redundant or un-necessary comparisons. "A>7 AND A>5" --> "A>5" The A>7 is thrown away. It's static code analysis, not short circuiting. |
|
May 2 |
comment |
Force sql server to run query conditions as written? Add the query hint OPTION (RECOMPILE) It tells Sql to recompile the query each execution. And because the query plan will never be reused, sql can optimize out the sub query. |
|
May 1 |
comment |
Denying direct remote access to SQL Server yoy run the risk of locking yourself out with a whitelist only approach. I would do some trials runs of how to recover from a bad login trigger so you are familiar with the process. |
|
Apr 30 |
comment |
Deadlock : Behaviour of NOLOCK can you post the deadlock graph? |
|
Apr 27 |
answered | maintaining full text index on large table |
|
Apr 27 |
awarded | Organizer |
|
Apr 27 |
revised |
SAP Business Warehouse 0APO_LOCNO_ATTR datasource extraction edited tags |
|
Apr 25 |
awarded | Enlightened |
|
Apr 25 |
awarded | Nice Answer |
