Viewing 15 posts - 4,606 through 4,620 (of 7,191 total)
Almost. The non-clustered index contains the indexed column(s) and the clustered index column(s), just as the index at the back of a book contains the word you're looking up...
March 23, 2012 at 4:58 am
marlon.seton (3/22/2012)
March 22, 2012 at 7:39 am
If your source is a SQL Server table, just use the UPPER function in your T-SQL query.
John
March 22, 2012 at 6:23 am
Paul
I don't know how you do that. There's probably someone here who does, but even so, you may be better off posting this on some sort of development forum.
John
March 21, 2012 at 9:34 am
Do you not have direct access to the system you're inserting rows in? I think it would be a lot more transparent, not to mention maintainable, to have your...
March 21, 2012 at 9:18 am
It's not just a performance thing either. Once you have a script working, you can reuse it as many times as necessary, and you can easily promote changes through...
March 21, 2012 at 9:15 am
GuruGPrasad (3/21/2012)
select val.day,SUM(V.data) from val V join val Val on V.day<=val.day group by val.day,val.day
That'll work well for three rows, but will get more and more inefficient the more rows...
March 21, 2012 at 3:34 am
Tony
Search this site (or the internet) for "running totals", then have a try at writing something. Post back if there's anything you don't understand.
John
March 21, 2012 at 3:29 am
Roust_m (3/21/2012)
Because when you buy a licence, you buy...
March 21, 2012 at 2:44 am
If I remember correctly, you have to license every processor that the operating system has access to. (That's how it was in previous versions - please correct me if...
March 20, 2012 at 2:51 am
You probably need to read about JOINs. No need for row-by-row processing, and much quicker.
John
March 16, 2012 at 7:01 am
In a way, stored procedure do keep it simple. It's much easier to change code in a database than it is to change it in an SSIS package. ...
March 16, 2012 at 6:59 am
Why do you want to fetch the values one by one instead of as a set? What are you going to do with them?
John
March 16, 2012 at 6:50 am
Are there any parts of the SQL that are constant? You could put those into stored procedures that accept parameters. That way, your SQL string will be shorter...
March 16, 2012 at 6:48 am
Are you building the code and then executing it in an Execute SQL task? That's the simplest way, and, as far as I know, it isn't subject to any...
March 16, 2012 at 5:26 am
Viewing 15 posts - 4,606 through 4,620 (of 7,191 total)