283 reputation
15
bio website linkedin.com/in/cairnz
location Oslo, Norway
age 35
visits member for 2 years, 11 months
seen Jun 24 at 21:17

Working as a consultant in information management.

Picking my brain on some questions here is a hobby of mine.


Jun
14
awarded  Nice Answer
Mar
5
awarded  Editor
Mar
5
revised Consolidating indexes
you're to your
Mar
4
suggested suggested edit on Consolidating indexes
Feb
22
awarded  Yearling
Oct
27
comment Table schema column data type equivalents for Netezza 6 to SQL Server 2008
DOUBLE PRECISION is equivalent to float(15) - REAL is equivalent to float(6).
Sep
11
answered SQL Server Analysis Services - where do I store user logins?
May
11
comment How do long columns impact performance and disk usage?
+1 for his explanations of this. it's mandatory to watch his stuff :)
Apr
26
awarded  Autobiographer
Apr
8
comment Are there any guidelines for the “IBM Premier Level Business Partner”?
You need certain amount of "points" from certifications and similar per year to maintain a Business Partner status.
Mar
22
comment SQL Server 2008 R2 Express high insert slowdown possibly due to PAGEIOLATCH_SH
What's the table structure, index structure, query to insert, execution plan when this happens? You'll need those details in order to figure out what really goes on, without looking outside the SQL Server environment.
Mar
6
answered parallelism repartitions, ordering, and hash matches
Feb
23
comment Get the rank of a user in a score table
You'll have one scan to get the score list, and another scan or seek to do something useful with it. An index on the Score column would help performance on large tables.
Feb
22
answered Get the rank of a user in a score table
Feb
21
comment Clustered Index Update on Nonclustered Columns
Could also add that the non-clustered index also has the clustering key in the non-clustered index, just for additional information. In this case the IX_Name index (or whatever it is called), also has the id column since it is the clustering key
Feb
21
comment SQL Server 2008 R2 Express - Runs at an average of 2-3% CPU, but gets stuck at 100% sometimes
Turn on Profiler and look for errors and warnings (want to look at hash warnings and sort warnings, especially hash bailout). Run the profiler on a session that's trying to enter this "locked up state". When it runs slow, you would probably see quite some stuff being shown in the profiler. Also, open up another session and do "select status, wait_type from sys.dm_exec_requests where session_id = xx" and xx is the spid of the SP that is going on forever. This might give you an indication of what is going on. (My guess is spilling to tempdb).
Feb
21
comment Thwarting some awful parameter sniffing
when using set statistics time on, how much cpu time does each of the two alternatives take?
Feb
15
comment SQL Server Maintenance Plan Fails to Rebuild the Indexes
log the maintenance plan to file, might give more details here than "..."
Feb
6
awarded  Teacher
Feb
6
answered Historical reporting from the database with Reporting Services?