meta user
network profile
| bio | website | |
|---|---|---|
| location | New York, NY | |
| age | 51 | |
| visits | member for | 2 years, 4 months |
| seen | May 16 at 2:31 | |
| stats | profile views | 45 |
|
Jan 22 |
awarded | Yearling |
|
Jan 8 |
comment |
Was I right with locking? NOLOCK on DELETE's is deprecated; why would you want to delete uncommitted data anyway? |
|
Jan 5 |
comment |
Four db servers all identical, one is much slower than the others Double check the network settings, if they're set to auto they may have negotiated down to 100mb. |
|
Dec 24 |
answered | Performance gain by moving a large table from a database and referencing with a synonym |
|
Dec 14 |
comment |
Keep transaction log size under control during batch processing I would disable that and run a manual stats job, I wouldn't think it would cause a log run up like you saw though. |
|
Dec 13 |
answered | How do I run a batch file from a scheduled Job via SQL Server Agent |
|
Dec 13 |
comment |
Keep transaction log size under control during batch processing @QuickJoeSmith, Are you using auto-update on statistics? |
|
Nov 22 |
comment |
How can I have SQL Server listening on more than one IP address? Stop and start SQL service if you haven't. Check the SQL Logs in management studio from the last startup, it will list the IP addresses it is listening on. Also check netstat -an |
|
Nov 22 |
answered | What would I look for in SQL Server to determine if a user connected with Microsoft Access? |
|
Nov 21 |
answered | Linked server to SQL Azure very slow |
|
Nov 21 |
answered | How can I have SQL Server listening on more than one IP address? |
|
Nov 19 |
comment |
Is there any way to turn off the “loading” message when a page refreshes in Reporting Services? In 2008, open the properties window (F4), and click in the whitespace of the design panel, AutoRefresh is under Other |
|
Nov 18 |
comment |
Is there any way to turn off the “loading” message when a page refreshes in Reporting Services? In BIDS, it should be under the top menu Report / Properties / General; at least for 2005, I think they moved it for 2008 but it's in the same general area IIRC. I don't get the "loading" with my instance, even when refreshes take forever. |
|
Nov 18 |
comment |
Is there any way to turn off the “loading” message when a page refreshes in Reporting Services? what version of ssrs, and how are you doing the refresh? with the built-in "refresh every ... seconds"? |
|
Nov 12 |
answered | SQL Rebuild Index, Recovery Model, and db log filesize? |
|
Oct 29 |
comment |
Can I Simply Change A Transaction Log From Unrestricted to Restricted? true; i missed the change to simple part. how about add full backup job. |
|
Oct 27 |
comment |
Can I Simply Change A Transaction Log From Unrestricted to Restricted? and don't forget to add a log backup job. |
|
Oct 21 |
comment |
SQL Server 2008 R2 “Ghost Memory”? The only time I'd be concerned is when my sql server is using LESS than 82%! |
|
Oct 17 |
revised |
TSQL to find if server is listening on dynamic or static port clarify title |
|
Oct 17 |
suggested | suggested edit on TSQL to find if server is listening on dynamic or static port |
