Viewing 15 posts - 5,986 through 6,000 (of 6,041 total)
David Portas (5/13/2010)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 13, 2010 at 2:53 pm
- You said that drive C: is 68 GB, but how much disk space was free before running the stored procedure?
- Have you used Sysinternals FileMon or Process Monitor to...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 13, 2010 at 1:17 pm
Nowadays 30,000,000 is only somewhat big.
If you join a table that large, you'll want to return only the columns you need, and insure that lat least there is an...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 13, 2010 at 12:46 pm
When working with Microsoft development tools, if you find yourself struggling or spending a great deal of time implementing some repetitive task, then you're probably just doing it wrong and...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 13, 2010 at 10:27 am
I think that T-SQL could use something similar to HTML's #include server side include directive for inserting repetitively used blocks of code like error handling, auditing, or variable declarations.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 13, 2010 at 9:05 am
shannonjk (5/12/2010)
...I was just curious if there was any sort of intuitive file/filegroup structure one should follow if designing a complex database schema system.
This MSDN article describes some of the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 12, 2010 at 1:22 pm
shannonjk (5/12/2010)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 12, 2010 at 12:50 pm
GilaMonster (5/12/2010)
Do not, please, ever do that and run the run the generated script as-is. Or, if you do, let me know so that I can send you a proposal...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 12, 2010 at 7:49 am
satya.sakamuri (5/12/2010)
...
if i run the above script inmy sql query with selecting perticular database ....will the data in tables effect?becaz those are production live tables in that database.
could you plese...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 12, 2010 at 7:36 am
Grant Fritchey (5/11/2010)
Whether the DBA knows it or not, that data can get changed by circumstances. It's best that you know that fact in order to gauge best whether or...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 12, 2010 at 7:28 am
GilaMonster (5/11/2010)
As for the index usage, it's flushed when the DB is closed. Shutdown, restore, detach, offline. There's no way I know of to manually flush it. Eric, you said...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 11, 2010 at 2:18 pm
The sys.dm_db_index_usage_stats view exposes statistics about the usage of indexes. I don't know for certain, but I suspect this is part of what the DTA uses behind the scenes to...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 11, 2010 at 1:13 pm
You never stated what the error message is or what about the large file doesn't work.
I'm just thinking that when dealing with 1 GB sizes XML files, if you...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 11, 2010 at 9:25 am
field1 will be set to whatever (field1 + field2 + field3 - field4) equals when the UPDATE statement initially starts.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 11, 2010 at 9:17 am
Dobermann (5/11/2010)
Stumped. I need to find out when the value in Col3 (Dose) changes from the previous date (col5):...
...
... I only want to see rows 1, 2 & 3...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 11, 2010 at 8:22 am
Viewing 15 posts - 5,986 through 6,000 (of 6,041 total)