Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
7
Newest
 Teacher
Impact
~942 people reached

  • 0 posts edited
  • 0 helpful flags
  • 20 votes cast
Feb
25
answered SQL Server Concise List Of Trace Flags
Feb
5
awarded  Teacher
Feb
4
comment Issues with using a database snapshot to report off of production
Found this in my research... sqlperformance.com/2013/05/t-sql-queries/…
Feb
4
awarded  Editor
Feb
4
revised Insert where not already available for FK?
added 759 characters in body
Feb
4
answered Insert where not already available for FK?
Jan
30
awarded  Scholar
Jan
30
accepted SQL Server 2008 and extended properties
May
27
awarded  Critic
Jan
3
comment Speed up bulkinsert on sql server
Inserting into a heap table (no clustered index) will be the fastest. Try rebuilding it after the load or using staging database/table. See link stackoverflow.com/questions/7184067/…
Dec
26
comment How to move SQL server transaction replication from one server to another server
Have you tried googling?
Dec
26
comment SQL Server Stored Procedure - Does Raiserror affect performance
That's your architectural decision. With these trivial (performance-wise) tasks, you should lean on the side of maintainability and readability of your code.
Dec
17
comment SQL Server Reporting Services Upgrade/Migration
Is it running a DDL script in the background? Is this documented anywhere?
Dec
17
asked SQL Server Reporting Services Upgrade/Migration
Nov
21
comment Auditing access to a linked server
Refer to How to Trace to See if a Linked Server is Being Used?. It seems pretty straightforward. I'm going to be using trace to audit this...
Nov
12
comment Version control for database objects
@HLGEM, I think what you're painting is ideal but the op already mentioned that they do not have a budget for a dedicated dba. I think if you have a good group of developers and are working on non critical/business imapacting software.. you can get away with good/tight version control. Especially in a smaller development shops.
Sep
3
comment Why shouldn't we allow NULLs?
Was this a BI data modeling? You generally should not allow nulls in fact tables... otherwise, nulls are you friends when used properly. =)
Feb
18
awarded  Commentator
Feb
18
comment How to simplify SSAS deployment from DEV to PRO environment
Anyone have experience using TFS with analysis services?
Feb
12
comment What is the meaning of Microsoft Compatibility Level?
FROM table (NOLOCK) is supported in 90 (2005) and 100 (2008)