Viewing 15 posts - 421 through 435 (of 1,409 total)
rajsin7786 (6/23/2014)
many thanks, table is quite big not sure how do i go about moving data into temp table and then back to original table.
SELECT *
INTO #temp_table
FROM {original_table}
WHERE {filter on...
June 23, 2014 at 4:01 am
Tex-166085 (6/23/2014)
...I want to show the names of the jobs which have output tasks matching the in conditions in my reports...
Allthough sample data and desired output would help us much...
June 23, 2014 at 3:34 am
- make sure you have the proper index (on date_id), so the query could find the records quickly.
- delete in batches of 100.000 - 500.000 records (i.e. DELETE TOP (100000)...
June 23, 2014 at 3:14 am
Sounds like the amount of data has increased...
June 17, 2014 at 8:02 am
Can you (or did you try to) delete the maintenance plan? As stated in the article:
Now it is very simple. Just delete the maintenance plan. This maintenance had only one...
June 17, 2014 at 8:00 am
SqlMel (6/17/2014)
I actually thought "select distinct * ..." might raise an error.I have never used this and wonder why it would even be allowed.
A "SELECT DISTINCT * ..." is...
June 17, 2014 at 6:21 am
palotaiarpad (6/17/2014)
I hate DISTINCT *😛
"hate" is a strong word, but in this QOTD the DISTINCT is absolutely not necessary.
June 17, 2014 at 3:51 am
You could execute the first result with "SELECT...INTO #temptable" into a temptable and subsequently adding the results of the 2nd and 3rd query to this temptable. Return the complete temptable...
June 12, 2014 at 7:27 am
Do you get a specific error message or just a time-out of the query?
Can you look what is going on the SQL instance when the stored proc. fails? Is blocking...
June 12, 2014 at 7:16 am
You can change the default database in the properties of the LOGIN you are using. This is the most helpfull way if you only need to access one single database.
You...
June 12, 2014 at 7:07 am
Perhaps the new cardinal estimator of SQL2014 is not handling your database well. You can change it for a specific query by using a trace flag. Or you can use...
June 11, 2014 at 4:12 am
I suggest to script out your backup (and restore) command. The easiest way to get this script is to walk through the GUI like you used to do. But instead...
June 11, 2014 at 1:01 am
Did you restore the FULL backup with the WITH NORECOVERY or WITH STANDBY option?
June 10, 2014 at 7:41 am
AFAIK it is not possible to create a query from one Access database to another. If I read your post correct you try to query the Access databases from SQL....
June 10, 2014 at 7:35 am
Youll need "sp_help_revlogin" for copying logins on SQL 2000. See http://support.microsoft.com/kb/918992
June 6, 2014 at 8:08 am
Viewing 15 posts - 421 through 435 (of 1,409 total)