Viewing 15 posts - 19,276 through 19,290 (of 19,560 total)
I would be a little concerned on two fronts:
1) Possibly the neighbor has a child and has noticed things happening to the child, reported it to the daycare center 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
October 28, 2009 at 10:01 am
Bob Hovious 24601 (10/27/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
October 27, 2009 at 5:38 pm
GilaMonster (10/23/2009)
CirquedeSQLeil (10/23/2009)
repent_kog_is_near (10/23/2009)
Is the Density column in SHOW_STATISTICS stored in any DMV, so I can see the values for all the index in one shot.
You can try the table...
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
October 23, 2009 at 4:05 pm
repent_kog_is_near (10/23/2009)
If not, is there any other suggestions...
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
October 23, 2009 at 2:27 pm
Jeffrey Williams-493691 (10/23/2009)
CirquedeSQLeil (10/23/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
October 23, 2009 at 1:45 pm
based on experience, we have had the SAN occasionally decide that it was going to consume too many resources to resize the disk - and occasionally it has rebooted. ...
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
October 23, 2009 at 12:26 pm
Yes
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
October 23, 2009 at 12:21 pm
Once you have created the 'MYUSER' login, you then need to create that user in the database. Through the GUI, this can be accomplished by double-clicking your user under...
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
October 23, 2009 at 12:00 pm
Yes, put the logs on the san. When a SAN is available it is not uncommon to put the database files (data and log) onto the SAN and leave...
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
October 23, 2009 at 11:53 am
One hint would be to take the last CTE sample provided on the link.
Combine that with your subquery. My preference would be to take the subquery out and combine...
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
October 23, 2009 at 11:31 am
I found nothing in the WMI, other than the list of my installed instances.
Since sqlcmd checks UDP 1434 to see if there will be a response (and that can't be...
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
October 22, 2009 at 2:53 pm
Since you have no residual services and your registry is clean, have you checked WMI or attempted to changed the default port?
SQLCMD and OSql's method was to send out a...
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
October 22, 2009 at 1:49 pm
You may also want to check popular SW download sites such as MajorGeeks.
I have had success with various file recovery software downloaded from MajorGeeks.
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
October 22, 2009 at 1:00 pm
You should be able to do that. You will lose some of the 64 bit memory management and processing.
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
October 22, 2009 at 12:54 pm
I've used both Redgate and LiteSpeed in the past for backup operations.
I did not use ftp with either of them but rather saved the backup files to a different network.
Being...
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
October 22, 2009 at 11:35 am
Viewing 15 posts - 19,276 through 19,290 (of 19,560 total)