Viewing 15 posts - 7,156 through 7,170 (of 13,460 total)
upstart (7/14/2011)
... either covered their tracks really, really well or our default 'black box' trace for some reason did not capture anything regarding it....
In my career I've seen mostly careless...
July 14, 2011 at 12:50 pm
the trimmed field needs to be aliased...same as if you did a min or max, for example.
SELECT DISTINCT
T2.Number
FROM table1 AS T1
INNER JOIN (SELECT
...
July 14, 2011 at 11:07 am
don't know if you use other schemas than the default dbo, but this slight modification to the model prevents dbl.tblBananas from being dropped, but not TestSchema.tblBananas; probably a good enhancement...
July 14, 2011 at 10:36 am
scoleman_cambridge (7/14/2011)
July 14, 2011 at 10:07 am
i've done something like this with putting icons in a database, and i get a CRC value from vb.NET,and store it along with the varbinary(max) in the row;
it seemed a...
July 14, 2011 at 9:55 am
yes.
i just created and tested this trigger as a prototype.
i've created 4 tables, and tried to delete them, only one is successful, the others raise the expected error.
CREATE TRIGGER [TR_ProtectCriticalTables]
ON...
July 14, 2011 at 9:44 am
well good we eliminated that as being a possible issue.
how is the data being migrated from source to destination?
Somewhere in that process, it seems, would be the issue.
is it a...
July 14, 2011 at 9:31 am
what's the datatype of the destination table?
if the destination is INT or DECIMAL(10,0) you would loose everything to the right of the decimal point due to implicit conversions.
the minimum size...
July 14, 2011 at 9:08 am
lots of stuff doesn't look right here.
if you EVER call that proc more than once, it will fail because it creates a permenant table, but never drops it.
depending on how...
July 13, 2011 at 2:35 pm
anjaliv (7/13/2011)
I am creating a table in a stored procedure I have written. But when I call it from the above query, it returns an error...
July 13, 2011 at 1:20 pm
are you concatenating strings, and one of them is null?
you know the old SET @string = Firstname + ' ' + LastName,
where ofirstname might be null or something?
July 13, 2011 at 10:30 am
that's good news! i was also either a hardware /100%CPU pegged issue, or thinking maybe somebody dropped the indexes in the database, if everything was running slow would be the...
July 13, 2011 at 10:28 am
well it depends on your proc whether will work correctly or not, but you can call the proc via a 3 part naming convention, and explicitly naming the database and...
July 13, 2011 at 10:26 am
the general, wave of the hand, "it's all slow" is really hard to pin down.
One of the first places i'd look is statistics. updating at a minimum the statsitics of...
July 13, 2011 at 10:02 am
if that server has the SSMS tools installed with SQL 2005, you'll see that issue;
it's the GUI that decides to show the missing indexes, even though they might actually exist...
July 13, 2011 at 9:33 am
Viewing 15 posts - 7,156 through 7,170 (of 13,460 total)