meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | 38 | |
| visits | member for | 1 year, 9 months |
| seen | 5 hours ago | |
| stats | profile views | 24 |
MSSQL DBA and FirebirdSQL Database Developer
|
Oct 9 |
revised |
Schema blocking in READ_COMMITTED_SNAPSHOT clarifying reference |
|
Oct 9 |
answered | Set SA to weak Password in SQL Server 2012 |
|
Oct 9 |
answered | Schema blocking in READ_COMMITTED_SNAPSHOT |
|
Oct 4 |
awarded | Student |
|
Oct 4 |
asked | How to troubleshoot orm queries interfering with other applications |
|
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. |
|
Aug 22 |
answered | Why you want to avoid Dynamic SQL in stored procedure? |
|
Aug 3 |
awarded | Yearling |
|
Jul 27 |
answered | Long JOINS Returns No result all tables have one to many relationship with a particular table |
|
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 24 |
revised |
Efficient way of changing VARCHAR to NVARCHAR fields in a large table in SQL Server 2008? added 155 characters in body |
|
Jul 24 |
answered | Efficient way of changing VARCHAR to NVARCHAR fields in a large table in SQL Server 2008? |
|
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 27 |
answered | When to use TINYINT over INT? |
|
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). |
