meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 2 years, 4 months |
| seen | 16 hours ago | |
| stats | profile views | 128 |
|
2d |
awarded | Nice Answer |
|
2d |
answered | Index Seek vs Index Scan |
|
May 7 |
answered | Group Database Entries by time difference |
|
May 7 |
answered | Tool to view intermediate query results |
|
May 7 |
comment |
Is there a difference in performance between @date and getdate()? How much faster? Do you see any difference in the query plans if you run them in SSMS and ask for that to be output? |
|
Apr 22 |
answered | Storing data in PostgreSQL: One table or two? |
|
Apr 20 |
answered | Linked Server Risks |
|
Apr 17 |
revised |
Can I make sure two columns dont have the same value Spilling carrections, |
|
Apr 13 |
answered | Can I make sure two columns dont have the same value |
|
Apr 12 |
comment |
Use CASE to select columns in UPDATE query? @Colin: Aye, any update will pass through the DB's transaction log including updates that are esentially NoOps due to updating fields to have the same values they had before. As well as the potential for an immediate performance issue this could be an important factor if using replication, differential backups, log shipping, and so forth, as the extra row update operations will increase the space/bandwidth needed for those. |
|
Apr 12 |
comment |
Use CASE to select columns in UPDATE query? You can mitigate that problem complete by making sure your ON and WHERE clauses filter out all rows where no changes are needed, but that may mean repeating all your conditions both in the SET clause and the WHERE clause (unless there is a simpler overall check that is 100% equivalent to all those conditions combined). At that point this method may still be more efficient, but the multiple updates method may be easier to maintain. |
|
Apr 12 |
answered | Use CASE to select columns in UPDATE query? |
|
Apr 10 |
answered | How to Drop Tables using a variable in SQL Server? |
|
Apr 5 |
answered | Multiple Aliases in an SQL Query |
|
Apr 5 |
answered | SQL Server 2008 DB Performance on single disk |
|
Apr 4 |
awarded | Good Answer |
|
Apr 3 |
awarded | Nice Answer |
|
Apr 3 |
comment |
Why should an application not use the sa account Often when a vendor says they need to login as sa explicitly it means they simply haven't tested their app any other way (or did once and it fell over with an error they didn't look into before deciding "we'll just stick with sa"), which is not something that would fill me with confidence. Don't take this tack directly with the vendor though, enquiring more diplomatically will get better results! |
|
Apr 3 |
comment |
SQL Server database backup on Remote site I think this question would be better suited to the more specific dba.stacexchange. Don't cross-post though, I'll vote to move it and if others agree it'll get moved automatically. |
|
Apr 3 |
answered | SQL Server database backup on Remote site |
