Reputation
390
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 11
Impact
~18k people reached

  • 0 posts edited
  • 0 helpful flags
  • 17 votes cast
Jul
16
comment Diagnosing Blocking issues using Blocked Process report
what mode is mirroring in? are you using SAFETY ON / OFF ( SYNCHRONOUS MODE / ASYNC MODE)? That could be a part of your problem. If your transaction has to commit on 2 servers before returning to client, you can expect slow down due to your mirroring configuration
Apr
22
answered How to move a fairly large tsql table from one server to another server?
Mar
21
awarded  Notable Question
Jan
17
awarded  Peer Pressure
Jan
17
comment How can I make only *one* user controlled database
I did not. My fault. I have updated the syntax.
Jan
17
revised How can I make only *one* user controlled database
fixed syntax of command to deny permissions to database
Jan
17
awarded  Autobiographer
Jan
5
awarded  Critic
Jan
5
answered How can I make only *one* user controlled database
Jan
5
answered SQL Server drop and create all users in every DB
Jan
5
answered Why SQL server unload CLR assembly every midnight
Jan
5
comment Why SQL server unload CLR assembly every midnight
Can you post the exact message you see / error messages? Can you disclose more information about server configuration? How much RAM, CPU, 32-bit or 64-bit system & what version of windows?
May
17
revised How to select/count rows where the same value exists in a column but not in other column all at the same table
original answer was wrong. submitted new query.
May
17
answered How to select/count rows where the same value exists in a column but not in other column all at the same table
Jan
29
answered Failure to log in using just the server name
Jan
11
awarded  Yearling
Jan
3
awarded  Popular Question
Oct
12
answered Flat file manager TextQualifier not working
Aug
16
comment How can I store function names to be executed on a subset of rows?
it really depends, my suggestion was to use in case you had to use nested cursors. I would test the process doing 1. a cursor , 2. dynamic sql , 3. an SSIS Package (if process can be scheduled vs. run adhoc).
Aug
16
comment How can I store function names to be executed on a subset of rows?
The other option would be to do dynamic sql using the function.