Viewing 15 posts - 4,741 through 4,755 (of 8,416 total)
Jeffrey Williams-493691 (3/28/2010)
If you look at the calculation - it is not performing a calculation on getdate(), but rather on the results from the datediff calculation.
So it is. Sneaky...
March 28, 2010 at 10:35 am
Do let us know how you get on rebuilding that clustered index online in production 😉 :w00t: :laugh:
SAP don't advise index reorganization eh? Sigh.
March 28, 2010 at 10:29 am
GilaMonster (3/28/2010)
SwePeso (3/28/2010)
All records do have a "hidden" record identifier, when there is not primary key on the table.
I assume you mean 'clustered index', not 'primary key'.
The RID's there on...
March 28, 2010 at 10:24 am
GilaMonster (3/28/2010)
Garadin (3/28/2010)
My gut was telling me that was the case, but my google skills apparently failed me. I couldn't find anything on it. Anyone have a link?
%%LockRes%%...
March 28, 2010 at 10:21 am
endo64 (3/27/2010)
I know it is important for data integrity, but I was also curious about is it important for the query optimizer.
It can be useful. In some circumstances the...
March 28, 2010 at 8:53 am
Are you attempting to install directly from a CD-ROM (as opposed to the DVD format)?
March 28, 2010 at 8:46 am
In addition to the information Luke posted, you might find this reference useful:
March 28, 2010 at 8:42 am
rds207 (3/27/2010)
can anybody please help ne writing the condition here ,the procedure given in link is such a big one and i dont have permissions for doing so...
No-one's going to...
March 28, 2010 at 8:36 am
IntelliSense to 2005 instances was (accidentally) available in CTP5 and CTP6 of 2008, but removed from RC0.
There is a Connect item to vote for it to be re-instated:
https://connect.microsoft.com/SQLServer/feedback/details/341872/intelllisense-backward-compatibility
It currently has...
March 28, 2010 at 8:34 am
One option is to use the EXECUTE ... AT <linked_server> syntax.
See http://msdn.microsoft.com/en-us/library/ms188332.aspx
The full details are there, including the full syntax:
Execute a pass-through command against a linked server
{ EXEC | EXECUTE...
March 28, 2010 at 8:28 am
A very recent article on this site covered this topic in depth:
March 28, 2010 at 8:25 am
Maybe a simple example will help:
CREATE TABLE #Sample (A INTEGER NULL, B VARCHAR(3) NULL);
DECLARE @Param1 INTEGER,
@Param2 VARCHAR(3)
...
March 28, 2010 at 8:20 am
Bored, and feeling psychic. Try:
DECLARE @Item
TABLE (
code CHAR(3) NOT NULL PRIMARY KEY,
...
March 28, 2010 at 8:13 am
SELECT O.own_name, MW.mob_name
FROM owner O
JOIN junction1 J
ON J.own_id = O.own_id
JOIN mobile_wanted...
March 28, 2010 at 6:45 am
Viewing 15 posts - 4,741 through 4,755 (of 8,416 total)