Viewing 15 posts - 18,766 through 18,780 (of 19,560 total)
Is it a domain user?
It is possible that a domain user was added to your local user group on the server. Verify the "source" of the user.
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 12, 2009 at 11:50 am
What recovery model are you using?
If full, you should do a full db backup and then schedule transaction log backups.
Once the transaction log has been backed up, you will 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
December 12, 2009 at 11:47 am
I really thought about pulling a stunt last a doing the countdown all by myself. I knew I would miss it today.
Congrats Barry
As for your new Car...
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 12, 2009 at 11:41 am
9977
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 11, 2009 at 9:39 pm
Are you trying to add an account that only exists on the server that SQL Server exists, or are you trying to add a domain account?
What happens if you try...
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 11, 2009 at 9:36 pm
If you log off your RDP session and then back on, can you see the job at that point?
When you RDP, are you connecting to "console"?
While in your RDP session,...
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 11, 2009 at 9:26 pm
GabyYYZ (12/11/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 11, 2009 at 9:21 pm
george sibbald (12/11/2009)
DB in simple mode?no full backup taken yet?
Those are good candidates for the cause.
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 11, 2009 at 5:34 pm
Garadin (12/11/2009)
+---------------------------+
| Employees |
+---------------------------+
| EmployeeID int ...
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 11, 2009 at 5:25 pm
RAID DP is what NETAPP calls RAID-6 for their SAN implementations.
DP stands for double-parity.
From the NetApp docs
The performance of RAID-DP volumes is comparable to that of RAID 4....
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 11, 2009 at 5:06 pm
Are you saying this based on experience?
According to Microsoft http://msdn.microsoft.com/en-us/library/ms188388.aspx
PARTITION
Specifies that only one partition of an index will be rebuilt or reorganized. PARTITION cannot be specified if index_name is not...
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 11, 2009 at 4:57 pm
Has the job worked in the past?
Is there adequate disk space on your F: drive?
Please check your error log for messages and post here as Bru requested.
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 11, 2009 at 4:42 pm
Lynn Pettis (12/11/2009)
GSquared (12/11/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 11, 2009 at 2:50 pm
By the time the thread hits 10,000 y'all will be flatlined, passed out drunk from all the bear being passed around - bwahahaha 10,000 shall be mine (or anybody else's...
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 11, 2009 at 2:50 pm
farax_x (12/9/2009)
my sample query :
SELECT docId,DocSubject,docDate
FROM tblDocument...
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 11, 2009 at 12:56 pm
Viewing 15 posts - 18,766 through 18,780 (of 19,560 total)