Viewing 15 posts - 27,361 through 27,375 (of 49,552 total)
SELECT AssayID, LabNo, DateAssRequested AS DateAssayReq,
case when ReasonRepeat in (1) then 'Original Marker Wrong'
when ReasonRepeat in (2) then 'Additional marker Req'
when ReasonRepeat in (3) then 'Rejected at...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2011 at 8:00 am
Great. That query gives you the machine name and program name that the query was coming from. That should be enough information to track down the source, though you might...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2011 at 7:57 am
steveb. (3/15/2011)
if the table is on it's own filegroup then yes , otherwise no
Kinda, but not to an earlier point in time. Would need to restore filegroup then log...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2011 at 6:58 am
Not natively.
If you want that you will need a 3rd party product (Litespeed, SQLBackup, etc) or you could use something like Hyperbak that lets you mount a backup as...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2011 at 6:56 am
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1078297-146-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2011 at 6:55 am
tt-615680 (3/15/2011)
The user that is suppose to have run the particular query is not running anything at the time.
Then someone's using his login.
Did you check the things I mentioned?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2011 at 6:29 am
What do you mean 'the actual user is not logged in'?
Check sysprocesses, it will give login, host name (machine the query is running from) and program name (what app is...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2011 at 6:13 am
Ali Tailor (3/15/2011)
Hiyaar
you can see mine blog as biginer's bolog example.
Then I'll offer you a beginner's piece of advice.
DO NOT plagiarise other people's work. Your post on moving Master (http://mumbaisqldba.wordpress.com/2011/03/04/how-to-move-the-master-database-of-sql-server/)...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2011 at 5:50 am
Please note: 2 year old thread
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2011 at 5:30 am
Step 1: Evaluate whether or not it is a problem. No sense in doing anything if there's no problem.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2011 at 5:26 am
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1078220-19-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2011 at 4:43 am
Ok, clustered index you'd have to drop (that's an alter table since it's the primary key). Ss per Books online, disabling the clustered index completely prevents access to the table.
Since...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2011 at 4:21 am
Either should work, and they're pretty synonymous. That said, you only want to disable indexes that reference the column you're changing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2011 at 3:43 am
There's nothing that can be added to the table. You can either change the entire database to read committed snapshot (read up on it before you do that), or you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2011 at 3:40 am
In clustering the two nodes should be identical. That's hardware, OS, drivers, etc. Clustering a physical box with a virtual is definitely not having two identical nodes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2011 at 2:56 am
Viewing 15 posts - 27,361 through 27,375 (of 49,552 total)