meta user
network profile
| bio | website | linkedin.com/in/cairnz |
|---|---|---|
| location | Oslo, Norway | |
| age | 34 | |
| visits | member for | 1 year, 8 months |
| seen | Mar 4 at 22:07 | |
| stats | profile views | 4 |
Working as a consultant in information management.
Picking my brain on some questions here is a hobby of mine.
|
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 2008DOUBLE 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? |
|
Sep 13 |
awarded | Supporter |
