meta user
network profile
| bio | website | |
|---|---|---|
| location | Sydney, Australia | |
| age | ||
| visits | member for | 10 months |
| seen | 9 hours ago | |
| stats | profile views | 45 |
|
May 17 |
comment |
How to add rows/columns to the table in runtime in SSRS 2008 That's what I expected too but the current issue is when there are multiple courses, the original record gets repeated per course. Which is not what we need. Only the Course rows should be added, not the whole student record. I have a row group on StudentId, but it does not help. |
|
May 12 |
comment |
Data dictionary best practices in SQL Server 2008 r2 The post you referred me to(above) was a good starting point.Thanks for that. |
|
May 1 |
comment |
Image fades on the SSRS report Thanks Jon. Saving it as png file fixed the issue. |
|
Feb 26 |
comment |
Choosing the right algorithm in HashBytes function @Paul: That's exactly right. Thanks for your further clarification. |
|
Feb 26 |
comment |
Choosing the right algorithm in HashBytes function Good, that's the way we'll try then. We can improve the performance also ensuring the data correctness (what we needed). Many thanks for your generous time and input. |
|
Feb 26 |
comment |
Choosing the right algorithm in HashBytes function Well, I was hoping not to have collision on SHA1 (for example based on this link: en.wikipedia.org/wiki/SHA-1 en.wikipedia.org ). However now that we can not rely on that, it means we can't use any hash value comparison. |
|
Feb 25 |
comment |
Choosing the right algorithm in HashBytes function Thanks Jon. The requirements tolerates no collision. So I think SHA1 is a safer option. We thought about defining index, but it's not possible. Because the columns used for joining are of Nvarchar(max). Even if the size was defined(e.g.: Nvarchar(4000), I don't think defining index on such a long column was not acceptable by SQL Server. I would double check though. |
|
Feb 24 |
comment |
Choosing the right algorithm in HashBytes function We need to join two tables on two nvarchar(max) columns. As you can imagine the query takes along time to execute. We thought it would be better to keep the hashsum value of each nvarchar(max) data and do the join on the hash values rather than the nvarchar(max) values which are blobs. The question is which hash algorithm provides the uniqueness, so that we don't run into the risk of having one hash value for more than one nvarchar(max). |
|
Feb 20 |
comment |
How to set the timeoffset in a Datetimeoffset column without changing the date part Well, I totally agree and understand your point to do it in presentation, but it is a requirement for our scenario, so I should do it in database. |
|
Feb 13 |
comment |
Can we minimise the risk of using xp_cmdshell? I see your point Aaron. You're right. |
|
Feb 12 |
comment |
Can we minimise the risk of using xp_cmdshell? Thanks. It seems what I was looking for. Could you please shed some light on how to do that? Do you mean I should enable xp_cmdshell in the stored proc where it's been called before using and then disable it right after the calling statement (when I'm done with that)? |
|
Feb 12 |
comment |
Restore the latest backup on the database Thanks for your comprehensive reply. I have access to the original server, can it make a difference? I was hoping to be able to do that without having to add a temp table. |
|
Jan 25 |
comment |
SQL Server Database Synchronization Well said Darin! That's it :) |
|
Jan 20 |
comment |
sql agent job hangs without any errors or warnings Sorry, I was typing the comments above from my mobile and made mistakes, which the forum did not let me to delete or edit them after 5 minutes. Do you have call of xp_cmdshell in your job? Is it possible that you are trying to use a resource that is not available at time of running Or the user you have set up to run the job (scheduled) does not have the required rights to access the resource? Also what is the wait type in your ssis package? Is it PREEMPTIVE_OS_PIPEOPS? If so, please check the link below: sqlservercentral.com/Forums/Topic802987-110-1.aspx#bm1339542 The links below al |
|
Jan 20 |
comment |
sql agent job hangs without any errors or warnings Do you call of xp_cmdshell in your job? What is the wait type in your ssis package? The links below might be helpful: |
|
Jan 2 |
comment |
Transaction and Try-catch in SQL Server Job Thanks for your helpful answer and fantastic website! However I'm wondering if still I can use this pattern with a simple DML statement (not a stored proc)? Also do we have to save the transaction as below? (I don't have a store proc to use): save transaction usp_my_procedure_name; |
|
Jan 2 |
comment |
Transaction and Try-catch in SQL Server Job Thanks for your reply, could you please give me a hint how to write it to a log? |
|
Dec 28 |
comment |
Calling a SQL Server job within another job Thanks for your reply. It seems we have to go for Option 2. I'm not quite sure whether I understood it correctly though. Do you mean I should create the scripts for both jobs, and then append steps of job2 to end of job1? Is that right? |
|
Dec 27 |
comment |
Restore a Database to a New database (T-SQL) I added 'RECOVERY', but still get the same error. |
|
Dec 10 |
comment |
Login failure when running a SSIS package from a SQL Server job Yes, it is done in ODBC connection, and the test connection can be established successfully there, but I know know how force SQL Server job use that credential, e.g: userId = dba not the SQL server Agent user. |
