Viewing 15 posts - 871 through 885 (of 1,162 total)
sqlchanakya (2/28/2011)
February 28, 2011 at 6:05 am
Whether you have triggers on a table or not has no bearing on whether transactions are written to the transaction log. All transactional operations are logged (in all recovery models)...
February 28, 2011 at 5:59 am
As advised, it's due to char's being padded to their full length, even with empty strings.
Also, are you aware there's a built in function called REVERSE? 🙂
February 25, 2011 at 3:12 am
What are people's thoughts on whether an update operation on a 10 million row table (a selective update, but probably around 1-2 million rows affected) holding 400,000+ Page locks? Shouldn't...
February 24, 2011 at 10:25 am
steveb. (2/24/2011)
chris.stuart (2/24/2011)
mark.marsh (2/24/2011)
February 24, 2011 at 8:44 am
Trying to deploy database code to a company and make it unreadable to their DBA's is a recipe for disaster. In the thread in question, the thought the OP had...
February 24, 2011 at 6:42 am
As you're posting it in the SQL 2008 forum, I'll assume that's the version you're running.
In which case, Table Valued Parameters suit this requirement nicely:
http://msdn.microsoft.com/en-us/library/bb510489.aspx
If you're not using 2008 yet,...
February 24, 2011 at 6:13 am
Depending on the width of the join columns (e.g. if it's just on a PK field or a large combination of columns you're performing the match on) you could potentially...
February 23, 2011 at 8:50 am
parthi-1705 (2/23/2011)
You no need to hardcode the months,we can get them by
Select datename(month,getdate()-30)-- Last Month
Select datename(month,getdate())-- Current Month
Select datename(month,getdate()+30)-- Next Month
need to pass the...
February 23, 2011 at 2:57 am
Quite a few very experienced people have given exactly the same assesment of what you're planning to do and advised strongly against it.
Not much more I can say really other...
February 22, 2011 at 10:00 am
If you're just moving SQL code into a CLR procedure and executing it from there, you can obfuscate the .Net code until the cows come home, it will still be...
February 22, 2011 at 9:50 am
No, as far as I'm aware, it's not possible.
You must have default parameter values for the schedule to work
February 21, 2011 at 9:48 am
It doesn't work like that. What you're asking is for every row in Table1, join it to every row in Table2 where the ID is different, so ID 1 and...
February 21, 2011 at 4:09 am
sdffdfad faadffad (2/18/2011)
February 18, 2011 at 10:42 am
With Encryption isn't real encryption - it's very easily reversible.
There are no ways to truly hide every command you run against a SQL Server. SQL code is not source code...
February 18, 2011 at 6:29 am
Viewing 15 posts - 871 through 885 (of 1,162 total)