370 reputation
211
bio website sqlserverupgrade.com
location Miami, FL
age 33
visits member for 3 years, 3 months
seen Apr 14 at 19:02

Database and Business Intelligence Practitioner


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.
Aug
5
comment In which form Microsoft SQL password should be given when creating a user?
seems to me that what you are concerned with is validating the password. To validate I suggest using SQLCMD utility. I typically validate by running SQLCMD with the following query."PRINT CAST(@@SERVERNAME AS NVARCHAR(100))+ ' | ' + CAST(SUSER_SNAME() AS NVARCHAR(100)) + ' | '+ CAST(DB_NAME() AS NVARCHAR(100)) + ' | ' + CONVERT(VARCHAR(20),getdate(),120) "
Jul
3
comment How can I store function names to be executed on a subset of rows?
is it required to run one row at a time? you could probably use the cursor for each different accountTypeId then process sets of rows "where accountTypeId = x". You may need to add validations, so that you can ensure the function results don't violate business rules. e.g. consider. update accounts set balance = fn_x(accountID) where accountTypeId = 'P' and fn_x(accountId) >= 0. Say for instance you don't allow balances to go below zero. You still get benefit of set based operation, but run function across all records of a specific type which don't violate rules