Viewing 15 posts - 1,276 through 1,290 (of 3,221 total)
As one who is an "Old Hand", you should be well aware that to get tested help from those volunteers that want to help you, you should post your table...
April 18, 2011 at 1:10 pm
To help those who are willing to help you, please post table definition,sample data and expected results, using the outline/method which you will be able to read and refer to...
April 17, 2011 at 6:25 pm
Are you in the same database when you parse and when you run otherwise. Would recommend that you use a two part identifier, for example EXECUTE.Dbname.dbo.IndexOptimize
April 16, 2011 at 7:43 pm
Good question - makes one recall the baics...
April 16, 2011 at 3:51 pm
1. In SSMS click on "Help"
2. In drop down window select "Index"
3. In window that in my case opens on the left side of the main form...
April 15, 2011 at 5:13 pm
lianvh (4/15/2011)
We deployed Online Indexing on SQLS erver 2005 Enterprise Edition . I was rather disapppointed when I noticed that this caused locks on the system and a...
April 15, 2011 at 4:09 pm
For an extensive list of using and manipulating DATE and TIME refer to this posting by Lynnpettis
https://www.sqlservercentral.com/blogs/lynnpettis/archive/2009/03/25/some-common-date-routines.aspx
For comparison of just dates in a DATETIME column. Set the time portion...
April 15, 2011 at 8:48 am
Yes, transaction file means transaction log file.
Is WLF will come into the picture here ?
What do you mean by WLF?
April 14, 2011 at 11:09 am
Have you attempted to use the DATALENGTH function on the message field of that DB table?
April 14, 2011 at 10:49 am
I assume by transaction file you mean the log file
Check points are issued by the system. If you want to know more look up checkpoint and lazywriter. It...
April 14, 2011 at 9:26 am
If memory serves me correctly, that folding down corner was a long time ago (even before the timewarp function) that was added to the site back in the days when...
April 13, 2011 at 5:10 pm
Duncan Pryde (4/13/2011)
I've submitted a few QotDs now and some have proved more popular than others. I'd therefore be interested to know what sort of questions people like, any...
April 13, 2011 at 9:27 am
Duncan Pryde (4/13/2011)
bitbucket-25253 (4/13/2011)
A good question. As of 9:20 AM only 28 percent correct answers.Your QOD has achieved one of the major objectives ... teaching
Thanks -...
April 13, 2011 at 8:08 am
A good question. As of 9:20 AM only 28 percent correct answers.
Your QOD has achieved one of the major objectives ... teaching
April 13, 2011 at 7:22 am
Without knowing the complete statement the only answer that I can give you is "It depends", not much assistance I know.
I would suggest that you post the table definition(s), some...
April 11, 2011 at 8:17 pm
Viewing 15 posts - 1,276 through 1,290 (of 3,221 total)