362 reputation
39
bio website
location
age
visits member for 3 years, 2 months
seen Dec 16 at 12:27

Nov
1
awarded  Popular Question
Apr
28
answered Why can't I script out CLR assemblies with SMO in Powershell?
Apr
28
comment Why can't I script out CLR assemblies with SMO in Powershell?
I think the schema filter is the issue. The SqlAssembly class doesn't have a schema property - it has owner instead - technet.microsoft.com/en-us/library/…
Apr
28
comment Why can't I script out CLR assemblies with SMO in Powershell?
Are the assemblies definitely in $schema? Does running $sourceDb.Assemblies | Where-object { $_.schema -eq $schema } produce output?
Apr
28
comment Why can't I script out CLR assemblies with SMO in Powershell?
Perhaps this is related to a specific combination of Powershell/SMO/SQL Server versions? This seems to be working for me on PS3 & SQL Server 2008 R2 SP2
May
2
comment SELECT COL_NAME(969262708, ORDINAL_POSITION) returns a NULL value in one of the rows
Could this be permissions related? BOL states that COL_NAME can return NULL if the caller doesn't have permission to view the object. Are any column-level permissions in place? Is the query running under an equivalent security context in test and production?
Apr
3
awarded  Enlightened
Apr
3
awarded  Nice Answer
Apr
2
awarded  Yearling
Apr
2
answered SQL Server uses only 1 CPU of 4 available
Mar
26
awarded  Organizer
Oct
10
revised How do I tell what is filling up the transaction log?
correct typo in title
Oct
10
suggested approved edit on How do I tell what is filling up the transaction log?
Aug
14
comment Is the SQLTRACE_FILE_BUFFER wait type documented? What does it indicate?
@Aaron - the default trace wasn't as heavily used as on other boxes in our environment; one average two or three objects being created per second, almost exlusively in tempdb - but disabling it made the wait disappear. We're going to get up to the latest service pack and see if anything changes.
Aug
14
revised Is the SQLTRACE_FILE_BUFFER wait type documented? What does it indicate?
added 141 characters in body
Aug
13
comment Is the SQLTRACE_FILE_BUFFER wait type documented? What does it indicate?
@Aaron - it's SQL 2008 R2 RTM (10.50.1600) Enterprise for X64. We haven't turned off the default trace; I will get that done.
Aug
13
comment Is the SQLTRACE_FILE_BUFFER wait type documented? What does it indicate?
@Aaron - thanks for your thoughts. We decided to try disabling the trace entirely, which had no effect - the same wait type continues to appear in the monitoring table.
Aug
13
revised Is the SQLTRACE_FILE_BUFFER wait type documented? What does it indicate?
updated
Aug
11
awarded  Student
Aug
11
asked Is the SQLTRACE_FILE_BUFFER wait type documented? What does it indicate?