1,245 reputation
1616
bio website travisgan.com
location Houston, TX
age
visits member for 2 years, 1 month
seen yesterday

Nov
5
awarded  Yearling
Aug
18
awarded  Enlightened
Aug
18
awarded  Nice Answer
Jul
2
awarded  Curious
Jun
12
awarded  Notable Question
Jun
2
awarded  Popular Question
Nov
21
accepted sys.dm_os_volume_stats return no result
Nov
21
answered sys.dm_os_volume_stats return no result
Nov
20
awarded  Popular Question
Nov
19
comment sys.dm_os_volume_stats return no result
@AaronBertrand Yes. I was using an account with sysadmin role.
Nov
19
comment sys.dm_os_volume_stats return no result
@swasheck I was using similar type of query like yours and it was returning NULL on columns from this DMF. Issue is that the DMF doesn't return any result.
Nov
18
asked sys.dm_os_volume_stats return no result
Nov
5
awarded  Yearling
Oct
19
comment net start sql service with startup option
At 'Using Startup Options for Troubleshooting' toward the bottom of the page.
Oct
19
accepted net start sql service with startup option
Oct
19
comment net start sql service with startup option
The article I linked actually shows how to use net start with start option using (/). I must have used backslash (it was late night) and didn't work. /m"SQLCMD" works fine. Thanks for the article, learn something new.
Oct
19
asked net start sql service with startup option
Jul
9
comment Lock hints on preconditions
Does the HOLDLOCK table hint makes dbo.Entities table SERIALIZABLE and hence the second example has lower concurrency than the first REPEATABLE READ example?
Jul
6
answered If there exist multiple similar Values than show Sum of a another column else Show simple Value
Jul
5
awarded  Fanatic