Viewing 15 posts - 10,711 through 10,725 (of 26,489 total)
In fact, you should not be shrinking your database on a regular basis. Should you determine how much space your databse requires over the next 3 to 6 months...
July 16, 2012 at 2:25 pm
lawson2305 (7/16/2012)
in the plan...
July 16, 2012 at 2:23 pm
GSquared (7/16/2012)
The Select Into syntax will create the target table. If it already exists, you'll get an error...
July 16, 2012 at 1:52 pm
Looks to me that you have an active VLF near the end of your t-log file.
July 16, 2012 at 1:50 pm
Lowell (7/16/2012)
Lynn Pettis (7/16/2012)
Lowell (7/16/2012)
are you running this through an ODBC driver, and the driver might be mis-translating the object names?
where is this code...
July 16, 2012 at 1:47 pm
Lowell (7/16/2012)
both commands will work perfectly in SSMS;are you running this through an ODBC driver, and the driver might be mis-translating the object names?
where is this code being executed?
I created...
July 16, 2012 at 1:23 pm
You may need to restart SQL Server. SQL Mail is not always reliable.
July 16, 2012 at 1:22 pm
lawson2305 (7/16/2012)
I run a tran backup and shrink every day. I append the backup daily except...
July 16, 2012 at 1:14 pm
VGish (7/16/2012)
What is the equivalent of ORACLE “MONTH_between “ in SQL ? I want in months….
I tried the Datediff, It is not the same..
See the example below…
select FLOOR(MONTHS_BETWEEN(sysdate,'07/20/2011'))
from...
July 16, 2012 at 1:07 pm
CELKO (7/16/2012)
July 16, 2012 at 11:43 am
And you will find a better one here: http://www.sqlservercentral.com/articles/Tally+Table/72993/.
July 16, 2012 at 11:21 am
It would help if you provided a more definitive timeline of when your backups and restores occurred. From there we could probably help you understand how the backups relate...
July 16, 2012 at 11:14 am
L' Eomot Inversé (7/15/2012)
July 16, 2012 at 10:57 am
Add to that you are joining 11 views together to form another view. How many tables do each of the views access? Do this views access some of...
July 16, 2012 at 9:35 am
rob.vig (7/16/2012)
--sp_Create_Accounts04 -
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
-- SET NOCOUNT ON added to prevent extra result sets from...
July 16, 2012 at 9:22 am
Viewing 15 posts - 10,711 through 10,725 (of 26,489 total)