Viewing 15 posts - 24,901 through 24,915 (of 26,490 total)
Matt Miller (4/15/2008)
gkruchten (4/15/2008)
"Consider using BIT data type columns for Boolean...
April 15, 2008 at 12:20 pm
Also out of curiosity, did changing the index have an impact on performance of the query?
😎
April 15, 2008 at 9:14 am
We have a linked server setup to access a MySQL database. The view that queries the MySQL database accesses the data with the following format: FROM MySQLServer...MySQLTable.
Hope this...
April 14, 2008 at 2:05 pm
Just a very simple example using just 12 rows of data. Look at the difference between how they are sorted (i.e. stored in the index).
The first data set is...
April 14, 2008 at 1:32 pm
This is just a guess, but I would not be surprised that if you looked at the Execution Plan, that the query is doing an Index Scan, and if you...
April 14, 2008 at 1:14 pm
A perspective employer could argue that a history of increasing salaries is a measure of competency. If you were doing the hiring and saw someone had remained at the...
April 11, 2008 at 3:06 pm
As the question specificaly mentioned SQL Server 2005, you could queue up a COPY_ONLY backup to start when the scheduled backup finished. This copy_only backup would not distrupt the...
April 11, 2008 at 1:58 pm
Hopefully you included the norecovery option in the restore of the full backup. if not, you will have to redo the restore of the full backup.
How many transaction log...
April 7, 2008 at 2:28 pm
Just one last question, based on the sample data provided, what is your expected output?
😎
April 7, 2008 at 2:25 pm
Lubo Petrov (4/7/2008)
properties of trn file created March 26 at 12:00:22 AM Modified at 12:01:27 AM
I'm want...
April 7, 2008 at 2:04 pm
roy.tollison (4/7/2008)
select * from table1
where ((col1+col2+col3) in (select (col1+col2+col3) from table2))
my col3 unfortunately contains the apostrophe. how can i get it to work correctly?
have you tried this:
select
...
April 7, 2008 at 2:00 pm
From what I can tell, then the only option short of sysadmin is the dbcreator fixed server role. This would allow them to create new databases, but also to...
April 7, 2008 at 1:28 pm
Looks like you'd have to assign them to db_owner in those databases that you want them to have backup and restore rights. If you only want to give the...
April 7, 2008 at 12:56 pm
I agree with with Matt. We just had an on-site instructor out here for a week, and we had him totally skip the Notifications part of the class just...
April 7, 2008 at 12:49 pm
GSquared (4/7/2008)
if (select Col1 from dbo.Table where id...
April 7, 2008 at 12:30 pm
Viewing 15 posts - 24,901 through 24,915 (of 26,490 total)