Reputation
1,394
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
8 29 54
Impact
~399k people reached

  • 0 posts edited
  • 0 helpful flags
  • 134 votes cast
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 Disabled SQL Server Endpoint - now I cannot login
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).
Aug
8
comment Doing a comparison on two csv files with no Primary Key
This is one way of doing it. Thanks for your help. In the meantime I figured out another way which is using HashByte function to get the hash value based on the a string consists of columns value and then use this value to see whether the record has changed between loads.
Aug
7
comment I have Fragmented Index on a empty table!
Many thanks for your comments. We are creating the database from scratch and as part of data migration, some tables need to be populated, some not (will be loaded by users through application ). I added page_count, index_level columns. The non clustered index on the empty table has got values below: Avg fragmentation: 57.71484375 Page counts:1024 Type_desc:NONCLUSTERED Index_level:0 Still I can't understand how an index on an empty table can have 1024 page_count?!!!
Aug
7
comment I have Fragmented Index on a empty table!
Thanks for your reply. That makes sense now. Is there any way to update the query above to exclude the empty tables?