Viewing 15 posts - 1,801 through 1,815 (of 2,838 total)
Ninja's_RGR'us (5/2/2011)
Brandie(5/2/2011)
Ninja, I can hardly throw stones on that particular point. Being a speed reader tends to work against me on the online forums.
Same here... hence #1 for amount of...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 2, 2011 at 8:16 am
Fal (5/1/2011)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
May 2, 2011 at 6:37 am
sqlsree (4/29/2011)
So which one works better when i have huge data? CTE or Subquery??
According to ColdCoffee, it shouldn't make a difference which you use. Use whichever feels more usable/understandable to...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 29, 2011 at 2:12 pm
The Dixie Flatline (4/28/2011)
SQLRNNR (4/28/2011)
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 28, 2011 at 3:18 pm
sql_2005_fan (4/28/2011)
Say like if addr2 has a null values it should not be added in the...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 28, 2011 at 2:04 pm
ColdCoffee (4/28/2011)
Stefan Krzywicki (4/28/2011)
ColdCoffee (4/28/2011)
Stefan Krzywicki (4/28/2011)
Also, you don't have to use a CTE for this, you can just use a subquery
Aren't CTE and SubQuery synonymous except for the fact...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 28, 2011 at 1:43 pm
hillock666 (4/28/2011)
I'm wondering about marking a computed column as persisted is useful when I'm using a query fully covered with an index.
I think that this haven't sense, because...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 28, 2011 at 1:42 pm
sql_2005_fan (4/28/2011)
@input1 uniqueidentifierwhen the input paramter is not set to null, we should definitley send the value for it,right?
@input1 uniqueidentifier=null
then we dont need to send the value to this parameter,right?
Thanks.
Right,...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 28, 2011 at 1:08 pm
MysteryJimbo (4/28/2011)
Stefan Krzywicki (4/28/2011)
MysteryJimbo (4/28/2011)
Alternatively, to reduce index fragmentation you could use NEWSEQUENTIALID()
If and only if they are generating new uniqueidentifier values for these inserts. If there are existing ids,...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 28, 2011 at 1:05 pm
ColdCoffee (4/28/2011)
Stefan Krzywicki (4/28/2011)
Also, you don't have to use a CTE for this, you can just use a subquery
Aren't CTE and SubQuery synonymous except for the fact that CTE has...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 28, 2011 at 1:04 pm
ColdCoffee (4/28/2011)
Stefan Krzywicki (4/28/2011)
ColdCoffee (4/27/2011)
declare @table table
( catid int, catname varchar(25) , refid int )
insert into @table values
(1 ,'Lenovo', 21),
(2 ,'Sony', 22),
(2 ,'Sony', 22),
(3 ,'Dell', 23),
(4 ,'Toshiba', 24),
(4 ,'Toshiba',...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 28, 2011 at 12:15 pm
MysteryJimbo (4/28/2011)
Alternatively, to reduce index fragmentation you could use NEWSEQUENTIALID()
If and only if they are generating new uniqueidentifier values for these inserts. If there are existing ids, those should be...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 28, 2011 at 12:05 pm
sql_2005_fan (4/28/2011)
CRETAE PROCEDURE testsp
@input1 uniqueidentifier
AS
SET NOCOUNT ON
INSERT INTO testtbl(uniid)
VALUES(@input1)
GO
I should send the uniqueidentifier value for this procedure as input,right?
or...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 28, 2011 at 11:55 am
ColdCoffee (4/27/2011)
declare @table table
( catid int, catname varchar(25) , refid int )
insert into @table values
(1 ,'Lenovo', 21),
(2 ,'Sony', 22),
(2 ,'Sony', 22),
(3 ,'Dell', 23),
(4 ,'Toshiba', 24),
(4 ,'Toshiba', 24)
; with cte...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 28, 2011 at 11:04 am
You can change that value under Tools --> Options --> SQL Server Object Explorer
Then change the value of Value for Edit Top <n> Rows Command to whatever value you'd like.
However,...
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 28, 2011 at 11:00 am
Viewing 15 posts - 1,801 through 1,815 (of 2,838 total)