Viewing 15 posts - 18,376 through 18,390 (of 19,560 total)
I agree with most of what has been said. Managers manage, know some technical, have the backs of their employees and trust the employees to do the jobs. ...
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
January 5, 2010 at 12:32 pm
Lynn Pettis (1/5/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
January 5, 2010 at 12:20 pm
Or would it be HI Ho, HI Ho, it's off to work we go?
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
January 5, 2010 at 12:04 pm
D i v y a R e d d y (12/28/2009)
HI
LO
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
January 5, 2010 at 12:03 pm
Bru Medishetty (12/28/2009)
Hardly Invisible is that what HI stand for ???
No, it is short for Hi-availability backups and how do I do them.
It is after-all in the Backups forum.
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
January 5, 2010 at 12:03 pm
gmamata7 (1/5/2010)
Hi,We have SQL Server 2005 in server A, in domain A and want to backup the databases to Server B, in domain B. Is this possible?
Thanks
Yes it is possible....
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
January 5, 2010 at 12:01 pm
What have you tried so far?
Are you getting any errors?
If you could provide code that you have tried with the point where you get hung-up on, we can better assist.
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
January 5, 2010 at 11:57 am
Greg Edwards-268690 (1/5/2010)
GSquared (1/5/2010)
tosscrosby-60625 (1/4/2010)
GSquared (1/4/2010)
tosscrosby-60625 (1/4/2010)
CirquedeSQLeil (1/4/2010)
GSquared (1/4/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
January 5, 2010 at 11:55 am
If you wish to create a separate backup for different ndf files, you will need to explore multiple filegroups. With multiple filegroups you can do piecemeal backup and restores.
Just...
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
January 5, 2010 at 11:52 am
You're welcome.
Sidenote: You will find that the assistance will be more accurate and much quicker with more precise terminology and detail.
I am glad that I could be of assistance.
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
January 5, 2010 at 11:49 am
Krasavita (1/5/2010)
This is new maintance plan and I copied code from 2000,but I am using in 2005
I suggest going back and creating a new maint plan, do not use 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
January 5, 2010 at 11:34 am
Krasavita (1/5/2010)
[Microsoft SQL-DMO] Error 21268: [SQL-DMO]Row or column specified is outside the range of the specified query result set.
this is what 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
January 5, 2010 at 11:09 am
Nice article and good info.
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
January 5, 2010 at 10:47 am
rustman (1/5/2010)
CirquedeSQLeil (1/5/2010)
rustman (1/5/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
January 5, 2010 at 10:36 am
What happens if you change the
IF @PAID_THRU < GETDATE() AND NOT EXISTS
to
IF @PAID_THRU <= GETDATE() AND NOT EXISTS
Also, have you thrown any print statements into it to see what...
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
January 5, 2010 at 10:34 am
Viewing 15 posts - 18,376 through 18,390 (of 19,560 total)