Viewing 15 posts - 30,571 through 30,585 (of 49,552 total)
SKYBVI (9/17/2010)
do any1 have MCITP dumps??
Braindumps are cheating. They are actual questions from the actual exams posted in violation of the NDA on those exams. Using or requesting braindumps can...
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
September 18, 2010 at 12:24 pm
The schema views that should contain this will be sys.columns, sys.foreign_keys and sys.foreign_key_columns. Joins are pretty simple and obvious
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
September 18, 2010 at 1:53 am
You can put anything you like into a resume. However if you do, make sure that it shows you in a good light. If you put such a comment there,...
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
September 18, 2010 at 1:45 am
touchmeknot (9/17/2010)
Thanks for the link. And yes, you are right about the wait type as well.So is there a solution to the problem ?
It's not a problem.
SQL runs queries...
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
September 17, 2010 at 3:39 pm
Not unusual.
The query's running in parallel, multiple threads executing a single query under a single spid. Nolock's not changing anything, because it's not blocking on a lock. If you look...
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
September 17, 2010 at 2:57 pm
No corruption, no crashes. A simple error saying that there's not enough free space when you go to insert data.
Do note that, for other than Express, the max size of...
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
September 17, 2010 at 1:54 pm
Very likely. Good to know.
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
September 17, 2010 at 12:41 pm
Alvin Ramard (9/17/2010)
When we hit 20000 inh the Thread should we start another thread labelled:"Are the posted answers getting better?" 😛
That's easy.
No!
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
September 17, 2010 at 12:41 pm
Brandie Tarvin (9/17/2010)
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
September 17, 2010 at 12:41 pm
That's likely. Can you ask them to run a trace and make sure that there's nothing else running.
If need be, I can check with an ex-dev team member about CheckDB...
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
September 17, 2010 at 12:39 pm
USE MYDB;
GO
select UserName, ISNULL(Cast(Userid AS VARCHAR(10)), '') AS 'UserID'
FROM Tablename;
GO
You can't set an int column to '', it'lll be implicitly converted to 0. Hence the int column needs to become...
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
September 17, 2010 at 11:55 am
WayneS (9/17/2010)
... but after the one on the woes of being abused on the forums. 😀
Don't think I'm qualified to write that one. After all, I'm the 'abuser'. 😉
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
September 17, 2010 at 11:52 am
Shouldn't. CheckDB just checks. It should not make any changes unless run with one of the repair options.
Is that the only job running at the time? No index rebuilds? Nothing...
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
September 17, 2010 at 11:47 am
vellenks (9/17/2010)
I still perplexed how come this happened since the subscriber has never been published.
I'd love to know as well. Was it ever restored from a backup of a database...
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
September 17, 2010 at 11:44 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
September 17, 2010 at 11:08 am
Viewing 15 posts - 30,571 through 30,585 (of 49,552 total)