Reputation
2,183
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
8 29
Newest
 Yearling
Impact
~122k people reached

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
3
answered TSQL- Column DataType Length
Jul
3
revised TSQL- Column DataType Length
code formatting
Jul
3
suggested approved edit on TSQL- Column DataType Length
Jul
1
awarded  sql-server
Jun
30
revised Is select * still a big no-no on SQL Server 2012?
added 235 characters in body
Jun
30
revised Is select * still a big no-no on SQL Server 2012?
added 1596 characters in body
Jun
30
answered Is select * still a big no-no on SQL Server 2012?
Jun
12
comment Cannot add foreign key constraint while creating table
If you have solved this yourself, do not change the title. Rather, post what you did to solve it as an answer, then ACCEPT your own answer.
May
14
comment SQL agent job, why is the job history showing that a step is still running even though the job has completed
What's the actual query to you are executing that is giving these results?
Apr
23
comment Fixing a corrupt Log File in small downtime window
That worked great, thanks!
Apr
23
accepted Fixing a corrupt Log File in small downtime window
Apr
22
comment Fixing a corrupt Log File in small downtime window
@MarkStorey-Smith Not a problem, they are aware in great detail and in writing of my position on this matter. At the moment, the hosting provider is on the hook.
Apr
22
comment Fixing a corrupt Log File in small downtime window
@MarkStorey-Smith Perfectly right. Unfortunately, disputes with the hosting provider are limiting the options. That's about as diplomatic as I can put it.
Apr
22
comment Fixing a corrupt Log File in small downtime window
@AaronBertrand Yes, those qualification are true and intended as implicit in my statement above. (I had qualified these originally, but ran out of room and had to edit for brevity)