Viewing 15 posts - 5,146 through 5,160 (of 14,953 total)
If a "database" is a means of storing data in a retrievable, orderly manner, then Excel can be a database. So can text files. Deep under the hood,...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 3, 2011 at 6:32 am
Rows in a table don't really have an "order" to them. They may be stored in a particular sequence (if they have a clustered index), but that's just a...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 3, 2011 at 6:27 am
GilaMonster (2/2/2011)
Please let me know by...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 3, 2011 at 6:18 am
Honestly, I'd hit the SSIS tutorials online to get oriented to building SSIS packages, if I were you. I could outline the process, but it won't be as easy...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 2, 2011 at 2:29 pm
Bulk imports usually bypass triggers. You can turn that off, but instead I'd recommend having SSIS do the inserts into the other table directly.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 2, 2011 at 2:27 pm
Coalesce or IsNull can still work, since the variable/parameter will have no value assigned.
The problem with this method, or similar ones, is that it tends to kill performance because of...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 2, 2011 at 8:28 am
Ninja's_RGR'us (2/2/2011)
Ninja's_RGR'us (2/2/2011)
Do you have a link to the connect ticket? I'm searching on sql 2008 and I'm not finding it!!Is this the one G?
https://connect.microsoft.com/SQLServer/feedback/details/177308/enhancement-to-isnumeric
That one's a good start.
The...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 2, 2011 at 8:25 am
It depends on how well you know the data. If it can only fit certain patterns, you can code against those. You have to assume then that the...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 2, 2011 at 8:05 am
shanureddy (2/2/2011)
Okay.. Now tel me if any other alternative other than dis two approaches..Not on update cascade & trigger.
Is there any other method???????????????
Yes, there are several other methods. These...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 2, 2011 at 6:49 am
Ninja's_RGR'us (2/1/2011)
DECLARE @tst VARCHAR(100)
SET @tst = 'fail'
SELECT 1 WHERE NOT @tst LIKE '%[^0-9]%'
SET @tst = '0123456789'
SELECT 1 WHERE NOT...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 2, 2011 at 6:39 am
rjohal-500813 (2/2/2011)
Would you also need to simulate a similar server load? Could SQL Server choose a different plan under different load conditions?
It won't choose a different plan, but the plan...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 2, 2011 at 6:35 am
This article has data on when a SQL Server view is updatable (scroll down a bit to find the section on it): http://msdn.microsoft.com/en-us/library/ms187956.aspx
Edit: Given the right code, any view can...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 2, 2011 at 6:29 am
Brandie Tarvin (2/2/2011)
SQLDCH (2/1/2011)
My boss has intimated that the BI side of things is a much better path to management. Would you all agree?
It really does depend, mainly on...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 2, 2011 at 6:27 am
Jeff Moden (2/1/2011)
GSquared (2/1/2011)
select *
from MyTable
where ip = '1.1.1.1'
or...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 2, 2011 at 6:18 am
Any other thoughts on what? You seemed to be asking about the order of the data returned from a Select statement. Do you have a different/other question?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 2, 2011 at 6:13 am
Viewing 15 posts - 5,146 through 5,160 (of 14,953 total)