Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
8
Newest
 Caucus
Impact
~1k people reached

  • 0 posts edited
  • 0 helpful flags
  • 20 votes cast
Aug
3
awarded  Caucus
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?