Viewing 15 posts - 1,021 through 1,035 (of 3,011 total)
If you need to split the backup into multiple files to get it to fit on multiple media, here is an example of a backup to 10 files. I...
January 13, 2011 at 9:27 pm
What do you need help with? Just moving the database?
Make a backup of the database, save it on removable media, ship it to the new location, and restore it....
January 13, 2011 at 3:04 pm
If the fill factor on the indexes is so high that there is no room to insert new rows without splitting the page you can get a lot of fragmentation...
January 13, 2011 at 2:40 pm
sqlbuddy123 (1/13/2011)
[SQLServer:Memory Manager][Target Server Memory (KB)] 221.000
[SQLServer:Memory Manager][Total Server Memory (KB)] 29.599
Why this disparity ? SQL wants to use 221 GB. But SQL is using only 29.5 GB.
But the...
January 13, 2011 at 10:10 am
Anna_SQL (1/13/2011)
But I got no records. There are acutally 50 records in the table for today.
The whole query is like below:
SELECT ParentUsername,...
January 13, 2011 at 10:03 am
where date = dateadd(dd,datediff(dd,0,getdate()),0)
January 13, 2011 at 8:59 am
update MyTable
set
column1 = case when column1 is null then 0 else column1 end,
column2 = case when column2 is null then 0 else column2 end,
... and so on ...
column10 = case...
January 12, 2011 at 10:23 pm
DeveloperDotNetSQL (1/12/2011)
Thanks for the fast reply, our local datetime format is DD/MM/YYYY, how will it know to convert 01/02/2011 to the 1st of February and not 2nd of January?
You should...
January 12, 2011 at 3:48 pm
Assuming your servers default date format is DDMMYYYY:
select convert(datetime,@date)+convert(datetime,@time)
January 12, 2011 at 3:36 pm
The high memory usage sounds like a good thing to me, because it means SQL is able to use it.
What do the Performance Monitor counters show for these counters?
SQL Server:Memory...
January 12, 2011 at 2:21 pm
sravanthiyerramreddy86 (1/12/2011)
Hi,I want it through registery query.
Why?
January 12, 2011 at 1:19 pm
Elliott Whitlow (1/12/2011)
January 12, 2011 at 1:17 pm
Why not use a SQL Query?
select SERVERPROPERTY('MachineName')
select SERVERPROPERTY('InstanceName')
select SERVERPROPERTY('ServerName')
January 12, 2011 at 11:22 am
The following message that shows the node name is written to the SQL Server Error Log everytime SQL Server is restarted.
The NETBIOS name of the local node that is running...
January 12, 2011 at 11:13 am
From The SQL Server 2008 Books Online (August 2008)
CREATE FUNCTION (Transact-SQL) topic:
"EXECUTE AS cannot be specified for inline user-defined functions."
In addition, EXECUTE AS can only be used in a...
January 6, 2011 at 2:05 pm
Viewing 15 posts - 1,021 through 1,035 (of 3,011 total)