Viewing 15 posts - 16,381 through 16,395 (of 19,560 total)
I would confirm with them what level of position this is to be. Also, confirm the environment and team. These things are necessary.
There should be no rush to...
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
March 16, 2010 at 2:25 pm
We are currently implementing this technology.
Lynn is correct about the pointers. However, with backups, those pointers do expire after a period of time.
The technology is to be implemented 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
March 16, 2010 at 2:23 pm
I agree with the others that it depends. How did you get offered the position? Did you interview and was the interview for a sr or jr position?
Never...
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
March 16, 2010 at 2:14 pm
GilaMonster (3/16/2010)
Steve Jones - Editor (3/16/2010)
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
March 16, 2010 at 1:50 pm
igngua (3/16/2010)
Ok!I need to know where can i look for the specific date when data changes gets comitted on a table.
thank guys!
To find when specific data changed 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
March 16, 2010 at 12:41 pm
Ditto that.
I suck at cursors.
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
March 16, 2010 at 12:31 pm
Roy Ernest (3/16/2010)
CirquedeSQLeil (3/16/2010)
Roy Ernest (3/16/2010)
I got my $500 yesterday. If I can write an article there, anyone here can write it for sure. 🙂
You wrote an article 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
March 16, 2010 at 12:29 pm
GSquared (3/16/2010)
CirquedeSQLeil (3/16/2010)
When people start congregating, I tell them I will let them know what the status is with regular email updates. Then I crank up the music 😀
This...
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
March 16, 2010 at 12:02 pm
Cliff Jones (3/16/2010)
I think the link http://msdn.microsoft.com/en-us/library/ms186289.aspx explains it very succinctly that 'Full database backups represent the database at the time the backup finished.'
Nice find.
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
March 16, 2010 at 11:33 am
When people start congregating, I tell them I will let them know what the status is with regular email updates. Then I crank up the music 😀
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
March 16, 2010 at 11:11 am
I agree with Lynn. This question is a little vague.
You state transaction log of a database, but you ask where data gets written. Please elaborate.
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
March 16, 2010 at 11:10 am
Grant Fritchey (3/16/2010)
CirquedeSQLeil (3/16/2010)
Grant Fritchey (3/16/2010)
What about a simple backup and restore? Or are you trying to build some sort of deployment mechanism?
Backup and restore would be my first inclination...
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
March 16, 2010 at 11:07 am
Steve-357 (3/16/2010)
Also, if your service account...
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
March 16, 2010 at 10:21 am
Grant Fritchey (3/16/2010)
What about a simple backup and restore? Or are you trying to build some sort of deployment mechanism?
Backup and restore would be my first inclination for users databases....
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
March 16, 2010 at 10:16 am
durai nagarajan (3/16/2010)
the backup is bappening only once in a day so i can schedule it after 30 mins after the backup schedule.
I might give it a little more 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
March 16, 2010 at 10:13 am
Viewing 15 posts - 16,381 through 16,395 (of 19,560 total)