Viewing 15 posts - 9,766 through 9,780 (of 19,560 total)
blandry (6/9/2011)
I am no expert here - but it appears that even though someone is running SQL 2008 R2, versions within that differ, and when they do, they cant "talk"...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 9, 2011 at 10:30 am
Brandie Tarvin (6/9/2011)
SQLRNNR (6/9/2011)
GilaMonster (6/9/2011)
Jim Murphy (6/9/2011)
The best part is that your posts are not useless point-getting restatements. Grrrr, I hate those.
You mean the parrot effect? Someone posts a...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 9, 2011 at 10:26 am
Grubb (6/9/2011)
CREATE TABLE [dbo].[RainbowQueue](
[RainbowType] [varchar](50) NOT NULL,
[RainbowKey] [varchar](255) NOT NULL,
[WorkDay] [datetime] NOT NULL,
[UpdatedRID] [bigint] NULL,
[SessionId] [int] NULL,
[BranchId] [varchar](20) NOT NULL,
[RecordUpdated] [datetime] NULL,
[RecordUpdatedBy] [varchar](20) NULL,
[RecordUpdateId] [timestamp] NULL,
CONSTRAINT [PK_RainbowQueue] PRIMARY KEY...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 9, 2011 at 10:22 am
crymea
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 9, 2011 at 10:18 am
No. It doesn't prevent the addition of an account to it, but it should be good to go already.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 9, 2011 at 10:18 am
Guessing here - the maint proc deletes from the table based on date. You created the index on that date field and now all is kosher.
Again, those are guesses...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 9, 2011 at 10:16 am
GilaMonster (6/9/2011)
Jim Murphy (6/9/2011)
The best part is that your posts are not useless point-getting restatements. Grrrr, I hate those.
You mean the parrot effect? Someone posts a solution and suddenly...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 9, 2011 at 10:06 am
No. That action should have been performed as a part of the install and is why you see those groups like that.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 9, 2011 at 10:05 am
You should place that second query after the first query you mentioned - not before it. The reason your variables are null is due to them not being set...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 9, 2011 at 10:04 am
The difference in results can be related to hardware of your workstations. Also, network latency will have some effect. Timing of when you run the queries can also...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 9, 2011 at 10:00 am
Gianluca Sartori (6/9/2011)
Thank you, Jason!
I just hope it's better than the crappy draft you just reviewed for me.
I haven't had the time...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 9, 2011 at 9:58 am
Have you tried openquery like the following?
insert openquery('my_linked_server', 'select column_1, column2 from table_schema.table_name')
values ('my_value1', 'my_value2')
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 9, 2011 at 9:55 am
Have you tried using data import/export?
Also, RedGate has a Data Compare tool that can do that for you.
Codeplex also has some tools that can help with this - such as...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 9, 2011 at 9:43 am
That was a nice article[/url] by Gianluca today.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 9, 2011 at 9:39 am
Nice article Gianluca.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 9, 2011 at 9:38 am
Viewing 15 posts - 9,766 through 9,780 (of 19,560 total)