Viewing 15 posts - 18,136 through 18,150 (of 49,552 total)
The way I search for plagiarism/copyright violation is to take a random sentence out of a paragraph and google for that sentence (in quotes)
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
June 11, 2012 at 1:27 pm
sivag (6/11/2012)
BUT I GOT ERROR WHILE CREATING THE TABLEIncorrect syntax near '('.
Yes, because as we both said, you have stray brackets in the table definition. There's one line that...
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
June 11, 2012 at 1:27 pm
SQLKnowItAll (6/11/2012)
i.e. If you have an index on columna, and columnb... Will a qury filtering solely on columnb be able to use this index?
Yes, actually it would, but that's...
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
June 11, 2012 at 12:51 pm
Same way you insert data into any other table, with an insert statement like the one you posted. What exactly is the insert doing or not doing?
Note that both your...
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
June 11, 2012 at 12:48 pm
Grizzly Bear (6/11/2012)
But how can I figure out what query used that index , be it...
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
June 11, 2012 at 12:33 pm
Possibly work space for the alter or other concurrent activity. You'll need to rebuild the clustered index before the table size shrinks, if it will shrink at all, which it...
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
June 11, 2012 at 12:21 pm
Information schema views are based off the underlying system tables, there's no lag and they cannot get out of sync (well not without the database being considered seriously corrupt)
My guess,...
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
June 11, 2012 at 10:52 am
You're running it in a database with compat mode set to 80.
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
June 11, 2012 at 10:48 am
You can write the exams in any order you like, you will get the certs once you pass all required exams and hold any pre-req certs.
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
June 11, 2012 at 10:01 am
brendan.tate (6/11/2012)
Do i need to?
Sure, otherwise how does SQL know what you mean
Dbo.Payloads is the table?
Maybe, but you haven't got any FROM clause, so again, how does SQL 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
June 11, 2012 at 8:25 am
Neither ContentReference nor ID are defined column aliases.
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
June 11, 2012 at 8:06 am
I recommend RedGate's SQLCompare and SQLDataCompare.
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
June 11, 2012 at 7:36 am
I had a suspicion that was who you were talking about. fyi, he's not an MVP any longer. He works for MS.
Also, this looks like the source
Published: April 2008
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
June 11, 2012 at 7:33 am
Because it's slow. A key lookup is a single row at a time, so if you have key lookups happening on 10000 rows,that's 10000 seeks of the clustered index.
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
June 11, 2012 at 6:56 am
Please read through this - Managing Transaction Logs[/url] and this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
It's not the replication distribution agent that, if stopped, causes the logs to grow. It's the log reader agent.
Also,...
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
June 11, 2012 at 6:42 am
Viewing 15 posts - 18,136 through 18,150 (of 49,552 total)