1,034 reputation
2526
bio website
location Sydney, Australia
age
visits member for 1 year, 8 months
seen Apr 7 at 6:09

Oct
12
accepted The best way to rename the tables after development completed
Oct
12
comment The best way to rename the tables after development completed
We are now at the development phase, but system has almost been completed for that component which these tables are to be renamed. System is now deployed to UAT.
Oct
12
comment The best way to rename the tables after development completed
Thanks for your good answer, but would you be able to advise me what you mean by : "This way you can change the app(s) one at a time (or even one reference at a time), without having to change all of them at once. ". Do you mean we should create the synonym one at the time for example first table t1, do the code changes, then table t2, etc?
Oct
11
asked The best way to rename the tables after development completed
Oct
9
answered SQL Server virtual log size
Oct
9
asked Tablix cells width issue in SSRS
Oct
8
accepted Merging tables with a 1 to 1 relationship in a database
Oct
8
answered Is there any way to run the definition of multiple stored procedure at a time?
Oct
8
asked Merging tables with a 1 to 1 relationship in a database
Oct
1
comment Closed loops in database model, does it affect the performance?
@Jon: Thanks for your answer, but I don't know what do you mean by 'specific example'? Above is the example of the issue I'm taking about.
Oct
1
comment Closed loops in database model, does it affect the performance?
Therefore to access 'QuestionaireResultsets', you have 2 options: Questionnaires-> Questions-> Answers-> QuestionaireResultsets OR direct join between Questionnaires and QuestionaireResultsets tables.
Oct
1
comment Closed loops in database model, does it affect the performance?
To give you an example, think about this scenario: Table 'Questionnaire is linked to 'Questions', table Questions is linked to 'Answers'. Table 'Answers' is linked to 'QuestionaireResultsets',but 'QuestionaireResultsets' is also linked to 'Questionnaires', which forms a loop.
Sep
30
asked Closed loops in database model, does it affect the performance?
Sep
26
accepted The best way to log access to SSRS reports
Sep
26
asked The best way to log access to SSRS reports
Sep
19
revised Query performance while using sqlcmd
deleted 7 characters in body
Sep
19
revised Query performance while using sqlcmd
added 272 characters in body
Sep
19
accepted Query performance while using sqlcmd
Sep
19
answered Query performance while using sqlcmd
Sep
17
comment Query performance while using sqlcmd
Thanks. I added "WITH RECOMPILE" to avoid getting stuck in parameter sniffing as suggested in the above post. It would force the sql server not to look for a plan and create one at run time.