Viewing 15 posts - 5,326 through 5,340 (of 6,041 total)
Thanks to code completion, I don't think developers today really spend a significant amount of time correcting syntax errors or invalid object references.
I think the old timers back in...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 12, 2012 at 11:58 am
Querying the INFORMATION_SCHEMA views can return columns with definitions that matche search criteria, and then you can also use a similar query to dynamically build other SQL queries against those...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 11, 2012 at 8:10 am
chaudharydpk0 (1/10/2012)
How we dealocate the memory of a row in a table in sql 2008 R2. please show the query if exist.
OK, I'll take a stab at interpreting your request...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 11, 2012 at 7:39 am
The thing about querying remote tables, especially when joining remote tables with local tables, is that the performance impact of the SQL coding tequnique is critical. I'm not sure that...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 10, 2012 at 7:41 am
islas.tonatiuh (12/22/2011)
I ran the last query without any results 🙁 still not idea about what is causing the size of transaction log backup.
You're saying the query against default trace returned...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 23, 2011 at 8:36 am
Check your server's maintenance plans to see what may have been scheduled.
Also, if there was something like an index rebuild, then a query of the default trace may reveal...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 22, 2011 at 11:48 am
islas.tonatiuh (12/22/2011)
One more question Sir, what's the interpretation for the operation and context columns retrieved from the query?I ran it but how can i use those results, because i saw:
e.g.
dbo.TransactionLog.PK_TransactionLogLOP_MODIFY_ROWLCX_TEXT_MIX
dbo.TransactionLog.PK_TransactionLogLOP_MODIFY_ROWLCX_TEXT_TREE
dbo.TransactionLog.PK_TransactionLogLOP_SET_BITSLCX_GAM
dbo.TransactionLog.PK_TransactionLogLOP_SET_BITSLCX_IAM
sys.sysallocunits.clustLOP_COUNT_DELTALCX_CLUSTERED
The...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 22, 2011 at 9:44 am
David Moutray (12/22/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 22, 2011 at 9:29 am
islas.tonatiuh (12/22/2011)
I was checking jobs but nothing comes up, any idea how can i know if indexes were rebuild or activity related with high transactional activity.Thanks
This query will summarize what...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 22, 2011 at 9:07 am
In addition to making the code less structured and less readable, another problem (at least for those who choose to use it) with T-SQL's implementation of GOTO is that it's...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 22, 2011 at 7:48 am
Elliott Whitlow (12/21/2011)
Jeff Moden (12/20/2011)
Concerning the question in the article...
If you had more pride in your employer, wouldn't you be a little more careful in caring for...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 21, 2011 at 9:34 am
I believe all organizations should get to know the people who handle their sensitive data and make sure they are happy. If they are not worth paying well or knowing,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 20, 2011 at 7:01 am
sqldba_newbie (12/15/2011)
i tried 'Incorrect syntax near the keyword 'option'.'.Were you able to parse it?
It seems in my previous example, I misplaced the option (hash group). Below are two versions of...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 15, 2011 at 11:15 am
sqldba_newbie (12/15/2011)
Eric M Russell (12/15/2011)
sqldba_newbie (12/14/2011)
sqldba_newbie (12/14/2011)
Eric M Russell (12/14/2011)
sqldba_newbie (12/12/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 15, 2011 at 9:15 am
sqldba_newbie (12/14/2011)
sqldba_newbie (12/14/2011)
Eric M Russell (12/14/2011)
sqldba_newbie (12/12/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 15, 2011 at 8:17 am
Viewing 15 posts - 5,326 through 5,340 (of 6,041 total)