meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | 38 | |
| visits | member for | 1 year, 9 months |
| seen | yesterday | |
| stats | profile views | 24 |
MSSQL DBA and FirebirdSQL Database Developer
|
May 7 |
comment |
pros/cons of different ways to store whether a record is one of two options? Good catch! I never thought of that hypothesis on the question, but it's really the right answer since all the bases are covered up. |
|
Feb 21 |
comment |
Manually set log file size after shrink SQL Server 2008 R2 @AaronBertrand - I agree with you in this. Log backup is nice for those who want almost 0 lost data. In this case, appear that some never changed the default recovery mode of model database........ |
|
Nov 30 |
comment |
We are running database maintenace with indexing the system, indexing fails due to locking? @Laurence: maybe they does not have Enterprise Edition? |
|
Oct 30 |
comment |
Query performance of a NULL vs an empty ('') varchar in SQL Server 2012 What is the distribution of values on that varchar column? Is empty string is, for example, a third of the total values on the column? More? Less? We need more information... |
|
Oct 23 |
comment |
What can speed up a SQL count query? @JonSeigel - My $0,05: Normal clustered indexes on normal table created offline applies an Sch-M lock on table. On a view, of course it's not needed but this means an alteration on the Create Index operation to create an special case for indexed view - which was done for SQL2012. IMHO, of course. |
|
Oct 23 |
comment |
How to troubleshoot orm queries interfering with other applications Seems the most aligned to the question, although the others got interesting info too. This one brough an way to enhance traceability using an MSSQL feature. |
|
Oct 18 |
comment |
How to troubleshoot orm queries interfering with other applications Seems you got the nearest so far. Have you tested if that bytes appear on "Binary data" of sql server profiler? |
|
Oct 17 |
comment |
How to troubleshoot orm queries interfering with other applications @dezso: see edit. |
|
Oct 16 |
comment |
How to troubleshoot orm queries interfering with other applications Seems you didn't got it. I don't want the SQL query that caused the problem. Profiler already gave me that (or those). What I looking for is the process to find the LINQ query(or queries) that are creating the problem (there's no SQL in the application) from a post-morten log (like Profiler). |
|
Oct 15 |
comment |
How to troubleshoot orm queries interfering with other applications Interesting... No one even risked an answer... |
|
Oct 9 |
comment |
Schema blocking in READ_COMMITTED_SNAPSHOT @AlexKuznetsov: you think the OP have an unindexed FK on a big table causing table scans? |
|
Sep 17 |
comment |
SQL Server - Database per company. How to query across databases? Unless those are for different customers of the paying customer, which certainly won't like to see their data shared with other customer's. Even error messages can reveal sensitive information - which is not desirable. |
|
Jul 24 |
comment |
What would be a good name for a job schedule? If you put the name of jobs that use the schedule on schedule's name you can create a trap to yourself, as you can create a new job and associate it with a already existing schedule forgetting of update the schedule name to include the new job... |
|
Jul 23 |
comment |
Efficient way of changing VARCHAR to NVARCHAR fields in a large table in SQL Server 2008? The more bytes to operate, more work to do. (Based on a SQL2008, not R2, installation). You read/write/compare/cache the double of bytes. But on R2 there is an interesting feature - cited on the discussion above - which is Unicode compression. That changes the map. Aaron has some blog posts on it and I'm personally very curious of it. (Although I have no actual practical use for nvarchars now). |
|
Jul 19 |
comment |
Efficient way of changing VARCHAR to NVARCHAR fields in a large table in SQL Server 2008? And it will tax your I/O subsystem if that table is really big (example: a table with 1M rows with a varchar column with string with average size of 40 chars. With varchar you'll have an table with 36Mb of char data, with nvarchar the same data will need 76Mb to be stored/read/written). |
|
Jul 19 |
comment |
Efficient way of changing VARCHAR to NVARCHAR fields in a large table in SQL Server 2008? Is this an effort to make database internationalized? Because your index keys will double (AFAIR, NVARCHAR spend 2x the storage space of the varchar fields) and that, if you have an index key particularly long, can create a key that cannot be rebuilt (index keys are limited to 900 bytes, AFAIR) |
|
Jul 12 |
comment |
Do you set an index on JOIN clauses or where clauses, or both? Her blog posts about indexing is a exceptional reading... |
|
Jul 9 |
comment |
Do indexes consume memory? +1 That Ms Tripp's articles are EPIC on clustering keys... |
|
Jun 30 |
comment |
Why does = NULL not work in Oracle? @NickChammas - thanks for the reference. I hinted, because I saw the wars that the question Null is a value or a state can generate... |
|
Jun 19 |
comment |
Running total with count? @MartinSmith It is a VERY BIG article at sqlservercentral.com (go to Author page and find his' articles on quirck updates). |
