Viewing 15 posts - 18,496 through 18,510 (of 19,560 total)
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
December 23, 2009 at 9:24 am
Valid points - but when its better than what you have, it isn't too bad of an option.
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
December 23, 2009 at 9:23 am
In addition to the checkident suggestion, when you reseed - you could reseed to -2 billion and change. This will give you that many more values for your table.
EDIT:...
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
December 23, 2009 at 8:10 am
Ray K (12/23/2009)
CirquedeSQLeil (12/22/2009)
Nice...Braves trade with the Yankeeshttp://sports.espn.go.com/mlb/news/story?id=4764085
Yankees get better in the BullPen and the Braves get Melky - hmmm not sure I like the trade.
Not yet sure how I...
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
December 23, 2009 at 8:06 am
EdVassie (12/23/2009)
If you want to get the path stored within master to match the real path of master, you will have to start SQL Server in single user mode and...
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
December 23, 2009 at 8:04 am
1st and 2nd error
http://support.microsoft.com/kb/315886
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
December 23, 2009 at 8:02 am
Either remove the devteam account from the local admins group
-or-
Remove local admin group from access to SQL Server ReportingServices Instance, then add the devteam to just the roles for which...
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
December 22, 2009 at 11:09 pm
Jeff Moden (12/22/2009)
CirquedeSQLeil (12/22/2009)
Jeff Moden (12/22/2009)
CirquedeSQLeil (12/22/2009)
...And chastising QODs:blush:
Heh... nah... "tweeking" is the word that I would chose on the one you're thinking of. 😀 I bashed one...
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
December 22, 2009 at 11:00 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
December 22, 2009 at 4:54 pm
The Dixie Flatline (12/22/2009)
Bring forth the Holy Pork Chop of Antioch! 😛
The number shall be 3, not 4 for 4 is after 3.
Welcome back Bob
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
December 22, 2009 at 4:10 pm
Good - thanks for the follow-up
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
December 22, 2009 at 4:06 pm
donna.harrison (12/22/2009)
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
December 22, 2009 at 3:39 pm
Gkhadka (12/22/2009)
I think the main concern for...
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
December 22, 2009 at 3:33 pm
Gkhadka (12/22/2009)
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
December 22, 2009 at 3:04 pm
acapucion (12/22/2009)
what if does not have the sql server, only SSMS and BIDS without SQL Server Developer Database Engine?Means it will require license?
You will still need to install 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
December 22, 2009 at 2:52 pm
Viewing 15 posts - 18,496 through 18,510 (of 19,560 total)