meta user
network profile
| bio | website | |
|---|---|---|
| location | Altanta Georgia | |
| age | 35 | |
| visits | member for | 5 months |
| seen | 3 hours ago | |
| stats | profile views | 36 |
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.
|
2d |
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 an sql database if it's status 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 |
|
Apr 25 |
comment |
Header and line item data source mismatch Fair enough. It sounds like you've done your research and you will be meeting the needs of the business users (the top priority), so you'll get no more complaint from me. If @Matt's answer or mine are acceptable, please mark it as the answer. Thanks! |
|
Apr 25 |
comment |
Header and line item data source mismatch How many distinct items exist in DataSourceA? Could you get a one-time export of them? Are the items conformed between the two data sources?The allocation doesn't have to be "right" in order to be useful. There must be some way to allocate the cost. Keep pressing the business users for a way to allocate down the costs. Never give up, never surrender! |
|
Apr 25 |
comment |
Header and line item data source mismatch Ok, I misunderstood your question. I was under the impression that both data sources reference the same order. I'd still be inclined to allocate down. Here are two methods to allocate down: proportionally (5 line items = 20% each) or 100% on the first item. From a business user's standpoint, they know that SystemA doesn't have per-line item costs, so if they drill down to the line item, the numbers are "calculated". They get the ease of use of having only 1 table. Are the line items consistent between the systems? Do they have standard costs you could use for allocation? |
|
Apr 25 |
comment |
Header and line item data source mismatch Does the same orderId from both both data sources, or are they disjoint systems? Or more specifically, if order 223344 comes from DataSourceA, does it also show up in DataSourceB? |
