greeshatu (5/20/2013)

---

Hi ..

I have a Column 'X' NVARCHAR(10) in Table 'X' which is mapped to Column 'Y' Decimal(23,10) of Table 'Y'

I want to check in Table 'y' which are...

jayoub1 (5/17/2013)

---

I am a total newbie and have a question to ask. I am the only DBA on a team managing several SQL servers and we have a new...

Agreed the error about the profile is the giveaway about database mail.

take a look at this thread and solution i posted a while ago to Script Out your database mail...

if DecId is an identity() column, can can infer that if the data was ordered by DecId, only the last record applies;

Since this looks a lot like homework, I'll give...

partitioning the data, just by itself, does not mean the queries hitting it will be faster;

only on the queries where the optimizer determines that all the data required is all...

MichaelDep the problem with a logon trigger is it hits them with a hammer without regard to which database, so if both the OLTP and the reporting database is on...

select * from YourTable

where FLOOR(YourDecimalColumn) = YourDecimalColumn --can be converted to an int without data loss

AND YourDecimalColumn < 2147483647 --max size of an int

your not real clear on the question;

if the column is typed as (23,10), then every non-null value is a decimal, by definition;

so do you mean which values are null?

do you...

ok, it's possible if you newly created or attached a database, it might not be in the intellisense cache;

usually it gets rebuilt on connecting to a server, but in SSMS...

you'll need to add them with different names, because your collation is non-case sensitive in the master database;

you could rebuild the server with a case sensitive collation, but that...

no ;

the public role is kind of like the "Everyone" group in Active directory;

it's required for the system to work, everyone belongs to it. it cannot be removed.

you can, hoever...

your issue is from the union of the query;

the aliases for column names always come from the first query in the union, and right now all the columns have...

nolock is always ignored for insert/update delete statements, as honoring that...

a very basic model to help you visualize the process:

SET ROWCOUNT 50000

WHILE 1 = 1

BEGIN

UPDATE dbo.myTable

SET MyField...

well, it's going to be an extra/separate process to save the view definitions, but you could at least automate it;

for example, you could guard all the view definitions, restore, then...