Viewing 15 posts - 7,261 through 7,275 (of 7,631 total)
Well, if replication is "out of synch" because it was stopped or it gets behind, it should catch up when it has a chance.
If it's "out of synch" because of...
[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 31, 2008 at 6:20 pm
K. Brian Kelley (3/31/2008)
This site can be that way. If you look at the Top Points lists you'll see folks who have "binged" in the last 30 days. 🙂
And, if...
[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 31, 2008 at 6:15 pm
It's still a mystery to me why Microsoft doesn't use the same COLLATION-based character normalization before hashing that it does before normal table lookups.
[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 31, 2008 at 6:10 pm
You need change the Linked Server definition properties to give access on the remote server whatever context your SQL Agent Jobs run under. I usually do this by creating...
[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 31, 2008 at 5:37 pm
Like this:
declare @file Nvarchar(max)
set @file = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\MyTests.bak'
RESTORE DATABASE [MyTests] FROM DISK = @file
WITH FILE = 1, NOUNLOAD, STATS = 10
FYI, you can...
[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 31, 2008 at 5:27 pm
It is important to realize that there are several types of Subquery:
1. Value Subqueries: These just return a single value per row and they look like this: (Select col1...
[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 30, 2008 at 9:52 pm
You want to look at dynamic SQL for 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 30, 2008 at 9:15 pm
Here is a link that explains republishing: http://technet.microsoft.com/en-us/library/ms152553.aspx
[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 30, 2008 at 6:32 pm
Have you looked at republishing?
[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 30, 2008 at 6:29 pm
Jeff Moden (3/29/2008)
Why not just post the problem(s) and see what you can get for nothing on this forum? Maybe people will even bid for the "job". 😉
Jeff, man...
[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 30, 2008 at 1:18 pm
chinni (3/30/2008)
they asked to use curser becoz it needs to check the records every time for the changes for every baselineobject...........
Doesn't Jack's script do that?
If not, then you'll...
[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 30, 2008 at 12:59 pm
Marios Philippopoulos (3/30/2008)
Yes, it's true that by trying to replace xp_cmdshell with SQL CLR code that is just as generic opens the door to even more...
[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 30, 2008 at 12:50 pm
rush2pooja (3/30/2008)
how do i decide the driver(jdbc/odbc)?
Hmmm, well SQL Server has "net-librarys" but I don't think that those are the same thing. If a MySql driver means what 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]
March 30, 2008 at 12:22 pm
You can use the CREATE DATABASE command or right-click on the "Databases" folderr under your server in Management Studio (called "SSMS" in these forums).
[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 30, 2008 at 6:19 am
Snapshot Isolation does impose some overhead, both performance and diskspace, but it does offer a very simple way to present a transactionaly consistent view to your users.
[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 29, 2008 at 10:05 pm
Viewing 15 posts - 7,261 through 7,275 (of 7,631 total)