Viewing 15 posts - 19,381 through 19,395 (of 19,560 total)
Odd how the answer I selected was the answer provided as being correct - but I got it wrong.
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
September 3, 2009 at 11:16 am
It goes to the protection of the consumer and their private data. Any person doing business in another state needs to protect the consumer data that resides in 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
September 3, 2009 at 10:20 am
sys.dm_os_performance_counters would be a good place to start.
And then it depends on what your needs are as to which counters to study and graph.
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
September 3, 2009 at 10:14 am
I agree with Grant, you don't necessarily need to master TSQL up front. The job will be more difficult without TSQL.
Other than books, you may want to check out...
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
September 3, 2009 at 10:08 am
Good information indeed.
Another one to add to the pile with Cal. Privacy, Sox, and PCI.
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
September 3, 2009 at 9:54 am
IA64 is for the Itanium 64Bit processor class.
X64 is for the Other sets.
From what you listed as installed, you should use the X64 version.
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
September 3, 2009 at 9:50 am
Keep in mind when setting the size, you want to be able to have enough space such that at least 3 months or so will be accomodated without an Autogrow.
If...
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
September 3, 2009 at 9:43 am
Another possible area that caused the extra space was alluded to in the first response by Steve. It is possible that there was a reindex as well.
Options for the...
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
September 3, 2009 at 9:34 am
Hadn't thought of it but....
Mud Farming comes to mind 🙂
Seriously...
Maybe an Engineer
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
September 2, 2009 at 5:42 pm
see
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
September 2, 2009 at 5:38 pm
Go ahead and remove the paretheses from your select clause
instead of
select
(inserted.PedNum,
...
inserted.[PedObs],
'2')
select
inserted.PedNum,
...
inserted.[PedObs],
'2'
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
September 2, 2009 at 5:26 pm
Maybe it should look something more like:
AND (tlkp_Item.Model = 'LCT 1680' OR tlkp_Item.Model LIKE '%[X]%')
Or completely eliminate the second Model condition.
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
September 2, 2009 at 5:21 pm
Let's not forget that all too often this is the same kind of stuff FTEs run into when accepting a new position as well. Bad design, unwillingness to change,...
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
September 2, 2009 at 4:25 pm
I was curious about the same thing recently. What I found was that when you have multiple files in a filegroup, you end up with the table splitting across...
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
September 2, 2009 at 4:16 pm
After some poking around at it, here is what I came up with:
When Granting alter, it grants alter any schema by default. This could be just as bad in...
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
September 2, 2009 at 4:05 pm
Viewing 15 posts - 19,381 through 19,395 (of 19,560 total)