9,350 reputation
1635
bio website
location
age
visits member for 3 years, 11 months
seen 9 hours ago

10h
answered SQL Server 2008R2 - how to install replication components
Nov
25
answered SQL Server De-duplication Trigger
Nov
22
comment Query execute slowly when changed compatibility Level of my database
We can't help at all with this sort of question without seeing the affected SQL statements/procedure. The only generic thing I can suggest to try is to run the procedure each way in SMSS with query plan output turned on and see if you can see any significant difference there. As the results of that to your question too.
Nov
17
answered SQL Server Standard Edition Memory Limit
Nov
14
comment SQL Server: performance of IDENTITY vs INT as primary key
NUMERIC(10) would be stored as 9 bytes per value, so there will be some performance difference compared to an INT (4 bytes) and to a lesser extent BIGINT (8 bytes). This is in part because when hitting disk you are pulling more pages as the rows take more room, and in part because the CPU has more work to do as it doesn't natively support loading and comparing 9 byte values in single instructions (manipulating 8, 4 2, and 1 byte values is natively supported. Whether either difference will be visible in the performance of you r application is something you'd need to benchmark to be sure.
Nov
14
answered SQL Server: performance of IDENTITY vs INT as primary key
Nov
13
revised Passing info on who deleted record onto a Delete trigger
Clarified on user types
Nov
13
revised Passing info on who deleted record onto a Delete trigger
Clarified on user types
Nov
13
answered Passing info on who deleted record onto a Delete trigger
Nov
11
revised Getting Time Duration
further typo corrections
Nov
11
comment Getting Time Duration
@Mark: Ah, that wasn't there when I first loaded the page and started typing. Will add pre-2012 notes later, my visitors are close to arriving now. The query with LEAD() should probably stay too as it may be useful to other passers-by.
Nov
11
comment Getting Time Duration
A SQL2012+ specific answer like mine... I didn't see this update until finishing that. Update the tags and add the other details mentioned a the top of my response to the question text, and I'll think about a SQL2008 compatible version later if no one else does first.
Nov
11
answered Getting Time Duration
Nov
6
answered How vulnerable is SQL Server 2000?
Oct
30
revised Filter table before join
added 419 characters in body
Oct
30
comment Filter table before join
You should add detail like that to your question. Diagnosing query performance questions is pretty "guessworky" when you don't have full details of the table and key/index stricture. An option that might be cleaner than your extra code is to add an index hint (adding WITH(INDEX(<index_name>))` after the from clause) though that does make your views/procs dependant on index names and *forces * they query planner to go a particular route when it might have chosen a better one later as your data grows.
Oct
30
answered Filter table before join
Oct
28
comment SSIS - insert system date variable as a execute sql task parameter
@aasim.abdullah: It would be a good idea to summarize the content of that link in an answer, that way if the link dies at a later date (and StackExchange doesn't) the information is still available here. Include the link in the answer of course for people who want more detail and for giving credit to the source.
Oct
27
answered Compare table content from different PostgreSQL 9.3 DBs
Oct
21
answered Upgrading hardware for MySQL. If we get SSDs, are CPUs likely to become a bottleneck