126 reputation
3
bio website
location
age
visits member for 2 years, 2 months
seen Mar 18 at 20:32

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
answered auditing access to linked server
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)
Feb
8
comment SQL Server 2008 and compatibility level 80
Easy way to find out... give it a whirl. There are some default setting that are different however... and some new keywords that can cause issues.
Feb
7
awarded  Student
Feb
7
asked SQL Server 2008 and extended properties
Feb
7
comment What mechanisms do you use to notify third parties of future schema changes?
Just out of curiosity, do people really use extended properties to self document your database?
Aug
21
comment Can NOLOCK in a stored procedure be overridden when executing it?
Mr 106k probably doesn't care too much about his answers being accepted... =) Let Mr 50k have it.
Mar
6
awarded  Supporter
Mar
6
comment Best database choice for a highly scalable web ticketing system?
You'd see a lot more gain in the write operation than read. (in Cassandra).