Viewing 15 posts - 10,396 through 10,410 (of 19,560 total)
this is the gist of the change that would be applied
CREATE TABLE [dbo].[yourtable](
yourcolumns,
PRIMARY KEY CLUSTERED
(
[PK_COlumn] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE...
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
April 19, 2011 at 4:20 pm
Does this table have any image, binary, or LOB (ntext, varchar(max) etc) data in it?
That data requires a different process in order to move it. In order to move...
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
April 19, 2011 at 4:08 pm
Craig Farrell (4/19/2011)
Companies really need to stay out of my personal life. I'm looking to work for you, I'm not moving into your house.
I agree - companies...
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
April 19, 2011 at 3:51 pm
WayneS (4/19/2011)
Greg Edwards-268690 (4/19/2011)
GSquared (4/19/2011)
Lynn Pettis (4/19/2011)
And once again Celko sticks his nose where it really wasn't needed. The OPs question had already been answered.
And Joe's answer, while demanding...
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
April 19, 2011 at 3:38 pm
Here's a couple of options/samples for you:
with emp_schedule as (
Select shift_start_time = '2011-04-01 07:00:00'
,shift_end_time = '2011-04-01 15:00:00'
,work_date = '2011-04-01'
,emp_id = 1
)
Select emp_id as "@Employee",DATEPART(wk,work_date) as "@WorkWeek"
,(Select DATEPART(dd,work_date) as "@Day"
,(Select shift_end_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
April 19, 2011 at 3:31 pm
Great article - thanks.
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
April 19, 2011 at 2:37 pm
please provide the table structure and some sample data.
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
April 19, 2011 at 2:22 pm
You're welcome.
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
April 19, 2011 at 1:43 pm
USE [msdb]
GO
EXEC sp_addrolemember N'SQLAgentOperatorRole', N'your user account'
GO
In the GUI add the person to the SQLAgentOperatorRole under the msdb database. (d-click persons login, click user mapping, put a check into...
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
April 19, 2011 at 1:37 pm
propensity
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
April 19, 2011 at 11:24 am
Thanks for the question. Can we see more of these types?
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
April 19, 2011 at 8:14 am
Thanks for the breakdown Craig.
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
April 18, 2011 at 3:13 pm
SQLDCH (4/18/2011)
CirquedeSQLeil (4/18/2011)
Craig Farrell (4/18/2011)
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
April 18, 2011 at 1:39 pm
GilaMonster (4/18/2011)
London's calling....(and my bank account is crying)
That would be a nice trip.
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
April 18, 2011 at 1:37 pm
Craig Farrell (4/18/2011)
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
April 18, 2011 at 12:50 pm
Viewing 15 posts - 10,396 through 10,410 (of 19,560 total)