Reputation
772
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
5 10
Newest
 Caucus
Impact
~118k people reached

  • 0 posts edited
  • 0 helpful flags
  • 73 votes cast
Jan
25
comment Physical Address Schema
@JonofAllTrades In my case, brazilian postal codes. In bigger cities, yes, the code identifies uniquely the street - my street have two codes because is interrupted by an square. Some BIG buildings have it's own postal code (or CEP, which is the name used here).
Aug
27
comment Avamar SQL Agent running against live SQL Server databases
The idea of asking them for making a POC is excellent. That will show if their solution can meet your concerns or not.
Apr
8
comment Getting the database from synonym base object
Never heard of that function!!! Brilliant! +1 and accept.
Apr
8
comment Getting the database from synonym base object
All the 4 object_piece is all the information I need. The and other information part is completely satisfied by your answer, @AaronBertrand. ;-)
Jan
31
comment Migration from SQL Server 2008 to Postgres 9.2
@a_horse_with_no_name I though that modification as a step BEFORE the OP start making the PGSQL database - still in MSSQL2008
Aug
21
comment Is there a DB that will allow the same field name with different cases?
@GreenstoneWalker: it make painkillers' vendors richer.
Jul
30
comment SQL Server Tuning a table for massive inserts
ALTER SCHEMA...TRANSFER ? Never heard of it. Interesting...
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...