Viewing 15 posts - 556 through 570 (of 5,103 total)
Seems like a bad code from a developer or a bad state on the server.
Do you have any other info?
February 9, 2009 at 9:14 am
DBCC CLEANTABLE is your friend. Run it first then Apply your script.
February 9, 2009 at 9:12 am
Although the article shows a simple technique there are many things that were omitted.
This is NOT a way to handle such things if there are strict requirements from security standpoint.
1....
February 9, 2009 at 8:51 am
Actually .NET has very robust exception handling abilities, and if you implement them along with TSQL exception handling there shouldn't be problems.
Right, a missing "catch" in an assembly is a...
February 5, 2009 at 4:34 pm
Although SQLCLR has great power I think it is very important to tell the reader that it also brings MANY undesirable things in.
- Bad Exception handling is just one of...
February 5, 2009 at 7:33 am
I would try with normal temporary tables first instead of table variables.
February 4, 2009 at 2:09 pm
Edward Boyle (2/4/2009)
A table with columns Interval and Value. These represent an activity that occurs at each minute of a 24...
February 4, 2009 at 2:05 pm
If you are a
Hybrid dba
Then you
kind of turn the server on.
kind of make sure the light stays on.
kind of shout if the light goes off.
...
February 4, 2009 at 1:23 pm
NotManyPoints (2/4/2009)
So I'm interested, for the first 6 years (can you give a rough time frame) so we can put that into context...
February 4, 2009 at 11:56 am
By the way, Our product communicate with SQL Server using TDS protocol, we do not really care about how long varchar(max) and nvarchar(max) columns can hold.
Really ?
Keep all those buffers...
February 3, 2009 at 4:10 pm
Jeff Moden (2/3/2009)
charlesz (2/2/2009)
Our product DB-WAN Accel communicates with SQL Server...
February 3, 2009 at 4:07 pm
riga1966 (2/3/2009)
It should be:
SELECT
IG_SRC_SYS_KEY = CASE
WHEN LEFT(ci.IG_CD,1) = 'D' THEN (SELECT SRC_SYS_KEY FROM SOURCE_SYSTEM_REF WHERE SRC_SYS_ID = 'DDA')
WHEN LEFT(ci.IG_CD,1) = 'G' THEN (SELECT SRC_SYS_KEY FROM SOURCE_SYSTEM_REF WHERE SRC_SYS_ID...
February 3, 2009 at 3:19 pm
NotManyPoints (2/3/2009)
Trying to work though the icons 😉
By the way, Are you a dba?
February 3, 2009 at 3:16 pm
Oh And I have seen *MANY* people using simply db_datareader and db_datawriter.
You could take those permissions away and then the "entire" DB is inaccessible 🙁
February 3, 2009 at 3:03 pm
Tom.Thomson (2/3/2009)
noeld (2/3/2009)
Suppose you need to prevent changes on ONE table while you are doing some maintenance...
February 3, 2009 at 3:00 pm
Viewing 15 posts - 556 through 570 (of 5,103 total)