1,069 reputation
31638
bio website
location Sydney, Australia
age
visits member for 2 years, 1 month
seen Sep 26 at 0:46

Sep
14
comment Tracking object use using SQL Auditing
Not sure if it helps, but just a suggestion, you might want to use SQL server profiler to set up a trace and target it to a file that can be analyzed later.
Sep
11
comment Does SSRS lock the table when querying?
In that case, most likely your report is trying to read a data that is locked by another user (e.g. someone is updating the same record). You can add "with no lock" to all "Select" statements, if reading uncommitted data is ok.
Sep
11
comment Creating the database on different file groups
What do you mean by system objects vs user objects? By user objects you mean views, assemblies, stored proc etc. ?
Sep
11
comment Creating the database on different file groups
Thanks for your answer. Does it cause any complication on the database maintenance though? Is there anything we should be careful about when we utilize multiple filegroups?
Sep
10
comment EXECUTE sp_executesql
A good alternative to temp table is defining it as CTE. It is very flexible and a great substitute for temp tables. Have you a look at the link below to see how to define CTE : codeproject.com/Articles/265371/…
Sep
6
comment Data obfuscation in SQL Server
I like your approach. Regarding given name and surname, I think if the data set is big enough, with a good level of variation, we can use it as the source, rather than having to download names from census website. Querying the data by SELECT DISTICT will tell us home many unique values we have to play with.
Sep
6
comment Data obfuscation in SQL Server
Mr Bownstone your explanation is excellent as always. Thank you. I'm going to check CLR function for this and have an eye on T-SQL as well. See which one fits better and is faster to build.
Sep
6
comment Data obfuscation in SQL Server
The legal requirements are determined by stakeholders. I should implement it now.
Sep
5
comment Error Occured during the login process
Can you try restarting the SQL server services? It might help.
Sep
5
comment Date format in SSRS
That make sense now :)
Sep
5
comment Date format in SSRS
I noticed MM is different from mm (representing the month) in the format function. At the beginning I had put dd/mm/yyyy which did not show the months correctly. But when changed it to dd/MM/yyyy it works fine. Do you know why?
Sep
4
comment How to backup/restore SQL Server database from command line similar to mysql
You can call the Sqlcmd above in a batch file. It would make it more convince to use, while you can assign the server name and user name differently if you need.
Sep
3
comment Page setup and print layout in SSRS Report
I like your first option. Thanks.
Aug
31
comment SSRS 2008 Report toggling between images for various field values
Thanks Mr Brownstone :)
Aug
27
comment SSMS Object Explorer Details causes deadlock while job is running
You might also want to try adding 'with nolock' phrase to all FROM s in the queries running in the job as part of the stored proc.
Aug
20
comment Providing an ad-hoc report facility for business users in SQL Server 2008 R2
Yes Andrew, they want to select the attributes and run the report to see the results. Is it possible through SQL server reporting services? How?
Aug
20
comment Passing values to variables defined in SSIS package at run time
For sharing with others, I put more context to the answer above. First you need to create an Xml file which can assign the values to rhe package variables in it. Then open the SSIS solution, click on SSIS menu and select package configuration. Mark it enabled and choose XML file you had created before. Here is a very good link showing you how to create that XML file: jasonstrate.com/2011/01/…
Aug
15
comment Performance comparison in ways a SSIS package can be run
I agree with you billinkc, I can see the difference when run the package in BIDs (debugging mode) vs when run it using dtexec.
Aug
13
comment Using SQL Profiler on SSIS package
For any other person benefit, as Eric mentioned above, to be able to trace a SSIS package in SQL Server Profiler, you need to first set the SSIS loggings int the package. Follow the steps below: Open the SSIS solution > Clik on SSIS menu > Add a new log while you choose the Provider Type as 'SSIS log Provider for Windows Event log' > Click on Details tab and select any events you are interested in logging > Save the log entry.
Aug
9
comment I have Fragmented Index on a empty table!
Martin, I added the columns you mentioned to the query and I get null for both on that index (belong to empty table).