Reputation
6,603
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
6 20
Newest
 Scholar
Impact
~427k people reached

Jan
15
awarded  Scholar
Jan
15
comment How to cast a list of values within xquery in SQL Server?
Thanks. Great solution.
Jan
15
accepted How to cast a list of values within xquery in SQL Server?
Jan
15
comment How to cast a list of values within xquery in SQL Server?
@Mr.Brownstone, in the current setting I do not have control over the schema. So, I cannot change it.
Jan
15
comment How to cast a list of values within xquery in SQL Server?
@Mr.Brownstone, thanks for the ?. That makes a lot of sense. See also: w3.org/TR/xpath-30/#prod-xpath30-OccurrenceIndicator
Jan
15
asked How to cast a list of values within xquery in SQL Server?
Oct
19
awarded  Enlightened
Oct
19
awarded  Nice Answer
Oct
10
awarded  Popular Question
Feb
24
awarded  Yearling
Dec
2
comment How can I create notification on user's connecting to database?
Do you have a backup of msdb from before the "cleaning"?
Sep
30
awarded  Explainer
Sep
29
revised How to get more information from dm_exec_query_stats
added 259 characters in body
Sep
29
answered How to get more information from dm_exec_query_stats
Sep
24
awarded  Autobiographer
Jun
9
comment Create a result for a line chart with dates
The risk on 2/21 is not 26. Instead it is unknown. Therefore you should not plot a 26 either. Just plot the dates that the measurements were taken on and leave gaps for the other days.
May
23
comment Shrinking large DB file not working
It is the primary filegroup...
May
21
answered How to restore symmetric key on the new database?
May
18
comment Shrinking large DB file not working
@JamesAnderson, can't right now as a full backup is currently running. That will probably take until Tuesday... However. There is log shipping setup and we do not use any of the other log reuse preventing technologies, so this should not be an issue.
May
18
comment Shrinking large DB file not working
@swasheck, yes. In fact most of the files is BLOB data (including the last extent)