Viewing 15 posts - 5,566 through 5,580 (of 9,707 total)
Check the server Event Viewer logs (especially Security) for around that time frame. What do they say?
The connection string would be helpful. Maybe a screenshot of the error as well.
July 13, 2011 at 7:24 am
dilipd006 (7/13/2011)
that means Even if i use different filegroups there is no improvement in DB performance if I don't use different physical disk drive right.
Pretty much.
Is there any improvement...
July 13, 2011 at 6:39 am
Koen Verbeeck (7/13/2011)
WHERE HASHBYTES('MD5', cast(ImageColumn1 as varbinary(MAX)))
=...
July 13, 2011 at 6:07 am
Koen Verbeeck (7/13/2011)
Gianluca Sartori (7/13/2011)
Here he goes again.I didn't notice it from the start.
Funny. 🙂
Which actually brings this thread back on topic! :w00t:
NO!!!!!!! Say it ain't so!!!
We can't have...
July 13, 2011 at 5:54 am
Can someone with Image data type experience please double-check my advice on this thread?
http://www.sqlservercentral.com/Forums/Topic1140743-391-1.aspx
July 13, 2011 at 5:40 am
First, I recommend changing that Image data type to a VarBinary(MAX) data type. Image is deprecated in SQL Server (has been since 2005) and will go away in a future...
July 13, 2011 at 5:38 am
If you put Read Only data on a different file group, you can actually change your backup options to only backup the Read-Write filegroup. However, that changes your recovery strategy...
July 13, 2011 at 5:23 am
ashkan siroos (7/13/2011)
1- If I use a computed column against SELECT COUNT(1) FROM ValidationError ... What will happen? which one is faster?
The only way to know is to try...
July 13, 2011 at 5:16 am
You don't use DDL to check that an image exists. You give us the DDL (the CREATE TABLE statement) to show us how your table is designed so we can...
July 13, 2011 at 5:12 am
Abhijit More (7/13/2011)
There is no difference in CURRET_TIMESTAMP / GETDATE() / SYSDATETIME(). all these function returns the date time of machine running SQL Server.
Careful with that assumption. Since SysDateTime is...
July 13, 2011 at 5:08 am
Before you take Howard's advice, consider this:
Will the datawarehouse always be 100 MB?
It is my experience that datawarehouses tend to grow exponentially, especially if there is more than one...
July 13, 2011 at 5:04 am
What exactly do you mean by "core range"?
July 13, 2011 at 4:56 am
Please post more details on your connection problems. Error messages and connection string (scrubbed so you don't give away secret info) would be helpful.
July 13, 2011 at 4:53 am
Per Books Online:
SYSDATETIME and SYSUTCDATE have more fractional seconds precision than GETDATE and GETUTCDATE
It's all in how detailed you want to get with your datetime value.
As far as the Current_Timestamp()...
July 13, 2011 at 4:52 am
Sharon,
Have you actually tried googling the issue yet? Backing up a standy server has actually been discussed in great detail elsewhere.
Here's the first link I found: http://www.sqlservercentral.com/Forums/Topic550669-357-1.aspx#bm551983
EDIT: Another option is...
July 13, 2011 at 4:44 am
Viewing 15 posts - 5,566 through 5,580 (of 9,707 total)