Viewing 15 posts - 1,336 through 1,350 (of 1,584 total)
hi everyone,as im new to sql server i would like you to help me with the stored procedures.
the requirement is to get the data in the dropdownlist.
i have a table...
November 15, 2011 at 1:39 pm
Can you post your SELECT statement?
November 14, 2011 at 11:42 pm
Have you tried WITH(INDEX(IX_PartyMain_incl_AddressEntitySourceRecordType_1_to_100000000))
?
November 14, 2011 at 11:03 pm
Well I wasn't able to figure out "why" this keeps happening but I was able to resolve it by manually running scome TSQL to clean up the problematic replication commands....
November 11, 2011 at 2:29 pm
@Breakwaterpc
Wouldn't you have to use OPENQUERY if the servers use NTLM authorization?
No, you wouldn't have to. However if you really wanted to you could use OPENQUERY but becomes...
November 11, 2011 at 1:50 pm
Try SQLEnlight.
Highly configurable, and works pretty well (IMHO)
November 9, 2011 at 10:34 am
Is there a reason why referencing another server in my domain won't work using "FROM [servername].[dbname].[owner].[tablename]"?
Even when referencing a server with the 4-part requires a linked server. Whether...
November 8, 2011 at 10:09 pm
Which version of SQL are you running this on? I ran it without error against 2008 EE...did you parse the query? Are you certain you selected all of...
November 8, 2011 at 9:47 pm
Understood Jeff, but if there will be queries like that running again (safe to say that it will happen again) then wouldn't it be considered a good practice to have...
November 8, 2011 at 7:50 pm
Take EVERYTHING that the SQL doctor suggests with several grains of salt.
You can take a fresh install of SQL Server with recent databases and run the Doctor and it will...
November 8, 2011 at 2:53 pm
You CANNOT view this in grid mode. Each line in the grid output is a new "ROW".
See for your self, Try this:
-- Run this in "Results to Text"
SELECT 'This!'...
November 8, 2011 at 1:49 pm
To reinforce NJ-DBA...
There is some reason that the file grew to 50GB. Usually we say, "leave the file as big as it grows to- if it got that big, it...
November 8, 2011 at 1:27 pm
Are you outputting te results to grid or text?
November 8, 2011 at 12:58 pm
Yep, you can.
If you're ever worried about data loss, take a full or differential backup before running the DBCC command
November 8, 2011 at 12:54 pm
If you're LDF files are growing and not going back to their respective sizes over time, you definitely have one of the two enabled. In fact, Full is the...
November 8, 2011 at 12:12 pm
Viewing 15 posts - 1,336 through 1,350 (of 1,584 total)