Viewing 15 posts - 6,541 through 6,555 (of 7,631 total)
Not automatically. I think that you would have to create Views/Synonyms in your CI schema to map to the objects in your CS schema.
Plus, I don't think that Case-Sensitivity...
[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]
June 21, 2008 at 1:49 pm
Normally, you wouldn't store them that way, you would just store them as some numeric and than leave the leading zeros as a task for presentation formatting.
[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]
June 21, 2008 at 1:43 pm
Jeff Moden (6/21/2008)
Dang... I just can't beat the kids anymore... 😀
Yeah, someone always calls the cops on you! :hehe:
[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]
June 21, 2008 at 1:40 pm
Oops, sorry. Forgot one of the steps:
--pre-compress the records:
Update TAB
Set Sex = CHAR(CASE Sex When 'M' Then 0 Else 1 End)
--Compress duplicates together and
--encode them into archetype...
[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]
June 21, 2008 at 1:11 pm
Vish:
vish (6/19/2008)
I have a table 'TAB' with 3 coulumns 'Name','Age','Sex'
and there is no primary key.
I have multiple duplicate data in my table. for eg..
ABC24M
ABC24M
LMN27M
LMN27M
LMN27M
PQRS25F
XYZ24M
XYZ25M
Now i would...
[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]
June 21, 2008 at 1:03 pm
Jeff Moden (6/21/2008)
[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]
June 21, 2008 at 12:59 pm
Jeff Moden (6/21/2008)
[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]
June 21, 2008 at 12:46 pm
ramu.guggilla (6/21/2008)
table - domain (domain_id, name,creator,date)
table - location (location_id, location_name, domain_id, date)
table - visit(visit_id, domain_id,location_id)
there are foriegnkey relations on these tables. i need...
[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]
June 21, 2008 at 12:05 pm
I want to add that IMHO, the reason that the work of ths ANSI SQL has seemed so out of step with users and practioners for the last 15 years...
[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]
June 21, 2008 at 10:57 am
Ok, this is all rather complicated, and I am not sure that I have it completely figured out, so anybody who knows better, please correct me:
First, here is a good...
[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]
June 21, 2008 at 10:27 am
Rerun Performance Monitor with the same counters that Gail listed, plus these addiitonal:
Memory\Available MBytes
Memory\Page Faults/sec
Memory\Page Reads/sec
Memory\Page Writes/sec
The following should have "*all instances" set:
PhysicallDisk(*)\% Idle Time
PhysicallDisk(*)\Disk Reads/sec
PhysicallDisk(*)\Disk Writes/sec
PhysicallDisk(*)\Avg Disk Queue Length
Processor(*)\%...
[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]
June 21, 2008 at 8:51 am
Jeff Moden (6/20/2008)
If I could find out how, I would in an instant. Anyone have a clue on how to get on that committee?
Yeah, I researched it some time...
[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]
June 21, 2008 at 6:55 am
Tony, Jeff, why don't you just join the committee? I don't think that its as hard as all 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]
June 20, 2008 at 11:31 pm
jezemine (6/20/2008)
if you want to automate the generation of scripts from the cmd line, I wrote a tool to do it. it's open source on codeplex:
jezemine: 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]
June 20, 2008 at 10:45 pm
TheSQLGuru (6/20/2008)
rbarryyoung (6/20/2008)
TheSQLGuru (6/20/2008)
Maybe take a look at ApexSQL's Script product, or search the web for some SMO code that will script out objects for you.
Not necessary. As I...
[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]
June 20, 2008 at 6:43 pm
Viewing 15 posts - 6,541 through 6,555 (of 7,631 total)