Viewing 15 posts - 43,666 through 43,680 (of 49,552 total)
Thanks Jonathan.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 19, 2008 at 11:11 am
No problem. 🙂
Ok, so what exactly will you be passing to the function? Something like 'C:\Somedir\SomeOtherDir\'? What do you want returning from the function?
Also, what do you need it for?
What...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 19, 2008 at 3:40 am
Did the drive the snapshot is on or the drive that the source DB is on run out of space?
There's no way to repair a corrupt snapshot. The only...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 19, 2008 at 2:37 am
MarlonRibunal (10/18/2008)
Well, I did not ask the *obvious* question. What is the compatible SQL Server Data Type for C# Type DirectoryInfo? I want to pass well, again it's quite *obvious*,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 19, 2008 at 2:28 am
Garadin (10/19/2008)
sql="SELECT * FROM TABLE WHERE Field ='" & MyVariable & "'"
rs.open sql conn2
Instead of
sql ="Exec dbo.MySP @Variable =" & MyVariable
rs.open sql conn2
So...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 19, 2008 at 2:26 am
jjssilva (10/18/2008)
This is what I got today at 18:48 local time (same as the server time).
2008-10-18 11:48:07.093Sat 10/18/2008
NULL
11:48 AM
NULL
That's showing that both SQL and the OS think that the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 19, 2008 at 2:21 am
Jeff Moden (10/18/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2008 at 11:51 am
senthil_gobi04 (10/18/2008)
How to use update Query using cursor in SQL Server
Don't.
Post the requirements for your update (table definitions, sample data, desired results), and we can help you write an update...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2008 at 11:38 am
Jeff Moden (10/18/2008)
Then, it should probably not be a function at all. It should probably be a stored proc or perhaps a view.
Probably.
I think at this point we...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2008 at 11:36 am
The error message is fairly clear. The data types don't match. A VARCHAR(max) is not the same as a DirectoryInfo. What are you expecting to be passing to this function?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2008 at 4:28 am
Leo (10/18/2008)
I never backup the transaction log even database model is -FULL. transaction log backup is not required for my environment at the moment.
You need transaction log backups in full...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2008 at 4:27 am
The only way that could be happening is if the ASP app is deleting from both tables. Can you find the delete statements that it's running? Use profiler if you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2008 at 4:22 am
With the table defs and foreign key that you've posted, that's not possible, unless there's an explicit delete been done from both tables.
-- using the definition posted above
INSERT INTO CMFP...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2008 at 3:59 am
Seems to be continued here: http://www.sqlservercentral.com/Forums/Topic588073-146-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2008 at 3:28 am
Very hard to say without knowing what you're trying to do. However, as was said before (http://www.sqlservercentral.com/Forums/Topic586167-145-1.aspx), the multi-statement functions tend to perform rather badly, so do be careful with...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 18, 2008 at 3:22 am
Viewing 15 posts - 43,666 through 43,680 (of 49,552 total)