Viewing 15 posts - 3,256 through 3,270 (of 7,631 total)
Looks "Row-by-Row" to me. 😛
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 23, 2009 at 7:11 am
You can do this in SQL Sevrer 2005 without the spatial data types. See this distance function here: http://www.sqlservercentral.com/scripts/T-SQL/65739/
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 22, 2009 at 10:08 pm
Florian Reischl (3/20/2009)
"Flo OR SQL Guru" is absolutely correct :hehe:
Now, now. "XOR" is exclusive, "OR" is inclusive 🙂
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 22, 2009 at 9:03 pm
Jeff Moden (3/21/2009)
------------------------------------------------------------------------------------------------------------------------
123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
You do realize this is classic RBAR, right?
😀
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 22, 2009 at 6:30 pm
craigl5678 (3/22/2009)
My past experience was to always put the database and log files on different partitions. ...
Should thee be split on another partition even tho its on the same...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 22, 2009 at 5:36 pm
RBarryYoung (3/22/2009)
You still have not provided any reason to take this more difficult approach.What are your real Goals in this?
I am still waiting for an answer to my questions, Mike.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 22, 2009 at 2:47 pm
Chris Morris (3/22/2009)
Dog-th Vader 5.1%
Bitter "Come over to the dark side". A well-balanced
beer with a...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 22, 2009 at 11:22 am
Andy Bod (3/22/2009)
Can you advise how, if I go for the multiple database option I can best keep the structure and sp's in sync? Can this be automated?
Hmm, I did...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 22, 2009 at 11:18 am
gopalchettri (3/22/2009)
I will try it again with Stored procedure.But it will be helpful for me if i get the...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 22, 2009 at 11:08 am
You still have not provided any reason to take this more difficult approach.
What are your real Goals in this?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 22, 2009 at 10:44 am
I was not recommending multiple databases, I was recommending things like Table Partitions, multiple Database Filegroups and SAN/NAS multidisk volumes (Raid 1+0, etc.).
You can use multiple databases, however there are...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 22, 2009 at 10:41 am
What rights does it have in SQL Server?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 22, 2009 at 12:01 am
We have already answered your question. It cannot be done the way you are trying to do it.
Why do you think that you can only use a trigger?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 21, 2009 at 9:51 pm
OK, supposedly it will create the tables for yo, however, you have to make sure that the account it runs under has the permissions to do that.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 21, 2009 at 9:48 pm
Yeah, the table name is pre-set also.
As I recall that's the whole trick to setting this up, you have to find the tables name(s) and defintions and define them ahead...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 21, 2009 at 9:38 pm
Viewing 15 posts - 3,256 through 3,270 (of 7,631 total)