668 reputation
211
bio website
location Finland
age
visits member for 1 year, 8 months
seen 2 days ago

Former ASP.NET Web Forms developer of 2 years, I'm currently working as one of the DBA's in a large project. TSQL scripting has become an increasingly interesting subject to me on a personal level, as I thoroughly enjoy doing it.


2d
asked CDC auditing - Unanswered questions
Jul
2
awarded  Curious
May
20
revised Network and memory waits after massive ALTER
added 565 characters in body
May
19
comment Network and memory waits after massive ALTER
We've been running several different DMV's, using SQL Sentry etc trying to diagnose the issues. These weird waits and blocks have appeared for a week now, and today we have the first really positive looking result. One of our background processing servers was bugged up and stuck. Only there was nothing in the DB pointing to that server specifically over all the others... Now for the past 2 hours, things have been working perfectly for the first time in a week though, so here's to hoping for the best!
May
19
revised Network and memory waits after massive ALTER
added 21 characters in body
May
19
asked Network and memory waits after massive ALTER
Apr
22
awarded  Citizen Patrol
Apr
22
comment Intermittent RESOURCE_SEMAPHORE_QUERY_COMPILE Wait Stats
As an after-edit, in our case it's appeared in a rather large DB after critical indexes/statistics were affected that were used by a large number of queries being run all the time.
Apr
22
comment Intermittent RESOURCE_SEMAPHORE_QUERY_COMPILE Wait Stats
Nevertheless, I've seen this happen several times and that wait has often been exactly what followed. Obviously I have no clue how common it is or if it applies here, but the methods mentioned above fixed it.
Apr
17
revised Intermittent RESOURCE_SEMAPHORE_QUERY_COMPILE Wait Stats
deleted 106 characters in body
Apr
17
revised Intermittent RESOURCE_SEMAPHORE_QUERY_COMPILE Wait Stats
added 1193 characters in body
Apr
17
answered Intermittent RESOURCE_SEMAPHORE_QUERY_COMPILE Wait Stats
Mar
24
accepted SQL Server 2012 Always On, during a massive DB change
Mar
20
comment SQL Server 2012 Always On, during a massive DB change
Thanks for the answer. Returning to this... are there any other steps needed to re-enable Hadr after the procedure has been done, other than just setting the property IsHadrEnabled back to 1 again? Also, by "Transfering the complete backup after..", do you mean that I should just let alwaysOn replicate the changes directly from the finished version of the primary group DB? OR should I actually restore the finished backup to the other groups first, and THEN re-enable Hadr?
Mar
12
asked SQL Server 2012 Always On, during a massive DB change
Mar
3
comment SQL Server - Recursive “find all FK connections for ID through the entire DB” query
Right, seems like the ones above can only resolve references from other types of objects, such as procedures.
Mar
3
comment SQL Server - Recursive “find all FK connections for ID through the entire DB” query
Since this is not going to be supported in the future, I tried to check into using sys.dm_sql_referencing_entities and sys.dm_sql_referenced_entities, but neither of them seem to work in SQL Server 2008 or 2012. I wonder why?
Feb
28
comment SQL Server - Recursive “find all FK connections for ID through the entire DB” query
We can't really make any substantial datamodel changes to accommodate this script, and a hierarchial table describing all potential pathways would basically be neverending. As I said, the number of tables and cross connections is quite staggering. Granted, the script needs to do some of this regardless, but the point is that eventually it will run out of connections for the originally provided ID. Otherwise it would basically have to map the entire DB with all its variations.
Feb
28
asked SQL Server - Recursive “find all FK connections for ID through the entire DB” query
Feb
1
awarded  Popular Question