1,921 reputation
321
bio website movingsql.com
location New Jersey
age 57
visits member for 2 years, 7 months
seen 2 days ago
coder & programmer of many defunct languages...

Sep
16
revised RESTORE failing with OS error 32, file being used by another process
added 221 characters in body
Sep
16
asked RESTORE failing with OS error 32, file being used by another process
Sep
11
comment Possible to optimize SELECT query involving XQuery functions selecting from elements with arbitrary number of child elements
Have you tried adding an XMLschema?
Sep
4
comment SQL Server 2008 logging
Before we can proceed, we will need to confirm some things. So first, execute this query from a sql server admin account and add the results to your question post above: SELECT * FROM sys.traces.
Sep
4
comment SQL Server 2008 logging
And finally, my guess would be that this is the requirement that is generating the problem: stigviewer.com/stig/microsoft_sql_server_2012_database_instance/…
Sep
4
comment SQL Server 2008 logging
@KyleRogers OK, here's an interactive access version: stigviewer.com/stig/microsoft_sql_server_2012_database_instance/…
Sep
4
comment SQL Server 2008 logging
@KyleRogers in any event, you should be able to find other copies of it by Googling "SQL Server STIG"
Sep
4
comment SQL Server 2008 logging
@KyleRogers Not sure what to do about it, it works fine for me, both publicly and even from behind an oppressive corporate firewall. I can only assume that your current wifi is blocking it for some reason. You could try it with an explicit "http://" on the front: iase.disa.mil/stigs/app-security/database/Pages/sql.aspx
Sep
4
comment SQL Server 2008 logging
Two important points for everybody: 1) this is very unlikely to be about the SQL Server transaction logs, but rather about some form of Audit Logging. And 2) this is probably very similar to the SQL Server 2012 STIG located here: iase.disa.mil/stigs/app-security/database/Pages/sql.aspx
Aug
13
comment Why does transaction log continue to grow in Simple recovery mode with nightly backups
Actually, I have observed a similar phenomenon myself at one of my clients' sites databases with SIMPLE recovery model. The logs don't grow (yet, anyway), but the used space in the log files does grow by a tiny bit every night. And it happens when the database backup runs. I have not yet figured out what is causing it nor whether its a problem or not.
Aug
12
comment Is there any way to do a SELECT query without any optimization in SQL Server?
Why do you want the un-optimized speed of a query? What are you trying to figure out? (and Why?)
Jul
8
comment Database instance and database
This distinction ("Database Instance" vs. "Database") only applies to Oracle, AFAIK, and is related to Oracle's implementation model.
Jul
8
revised Is select * still a big no-no on SQL Server 2012?
added 16 characters in body
Jul
8
comment Is select * still a big no-no on SQL Server 2012?
@CraigYoung The performance problem may be simplified in my description, but I don't think that it is an over-simplification. Performance problems from * can only occur if the * appears in the top-level select. As long as the top-level select explicitly lists only the columns desired, * appearing anywhere else cannot cause performance problems. However, I will edit my reply to clarify that it is only a potential performance problem.
Jul
8
comment Is select * still a big no-no on SQL Server 2012?
@CraigYoung Yes0, the View's Columns issue is the binding problem I mentioned in the footnote.
Jul
3
answered TSQL- Column DataType Length
Jul
3
revised TSQL- Column DataType Length
code formatting
Jul
3
suggested suggested edit on TSQL- Column DataType Length
Jul
2
comment Is select * still a big no-no on SQL Server 2012?
@Damien_The_Unbeliever Agreed, good point.
Jul
1
awarded  sql-server