Viewing 15 posts - 47,326 through 47,340 (of 49,571 total)
True. I should read more carefully.
February 22, 2008 at 2:15 am
Use a datetime. Format is a function of how you retrieve the data, not how you store it.
Look up Convert for a list of the formating options for datetimes.
February 22, 2008 at 2:12 am
Could you add a TOP 1?
SELECT TOP 1 f.forumid, forumname
FROM Forums f
LEFT JOIN Threads t ON f.forum_id=t.forum_id
LEFT JOIN (SELECT forum_id, MAX(postdate) as last_postdate FROM Threads GROUP By...
February 22, 2008 at 1:33 am
Despite its name, the timestamp datatype has nothing to do with times. It's a binary rowversion.
It you're wanting to store the date that the rows was inserted, then you need...
February 22, 2008 at 1:23 am
In SQL 2005's profiler's create trace dialog, on the second tab (event selection) there's a button at the bottom 'Column Filters' That will let you set whatever filters you like.
You...
February 21, 2008 at 11:09 pm
cheungh (2/21/2008)
4) create a new xyz.log file for the database
No need to do anything with any logs if you're emptying data files
Any links to the command empty using DBCC.
Books Online...
February 21, 2008 at 10:56 pm
Since they are the same filegroup, you probably need to run the DBCC SHRINKFILE with the EMPTYFILE option.
EMPTYFILE migrates all data from the specified file to other files in...
February 21, 2008 at 1:11 pm
It's not possible of SQL 2000. To use profiler, you must have sysadmin rights
February 21, 2008 at 1:05 pm
Probably not with SSIS.
Are there different filegroups, or are all the files part of the same filegroup?
February 21, 2008 at 11:13 am
Import the trace into a DB table, then query it for any rows where TextData Like '%alter%' and TextData Like '%database%'
It may take a while, but it'll be faster than...
February 21, 2008 at 11:00 am
Please can you post the table structure, some sample data and the expected results. It makes it much easier for us to answer your question.
Ref: http://www.sqlservercentral.com/articles/Best+Practices/61537/
Thanks
February 21, 2008 at 10:59 am
😀 I'm gonna be thinking of Star Wars every time I look at SQL 2008 now.
I foresee a while new set of abuses of query hints coming up soon.
February 21, 2008 at 10:49 am
I should have thought of that earlier.
Those aren't indexes. They're automatically created column statistics. The query optimiser creates those to better know the data distribution within a column.
You can drop...
February 21, 2008 at 10:18 am
I know you haven't created any inde3xes. I'm trying to identify what the entries in sysindexes are and how they got there.
Please run the following query and post the results...
February 21, 2008 at 2:58 am
Viewing 15 posts - 47,326 through 47,340 (of 49,571 total)