Viewing 15 posts - 42,631 through 42,645 (of 49,552 total)
nazaninahmady_sh (12/3/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
December 3, 2008 at 7:17 am
Edit: Didn't read the round up. Recalculating....
Edit 2: This one works.
declare @tbl table (Val numeric (8,2))
insert into @tbl values (0) -- to 0
insert into @tbl values (1.21) -- to 1.5
insert...
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
December 3, 2008 at 7:00 am
What does the schema of the destination table look like?
You said you had a query to copy the data over. Can you post it?
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
December 3, 2008 at 6:55 am
pri.amin (12/3/2008)
You are correct it has been asked before but the issue has progressed!!
It has? It's exactly the same error with exactly the same insert statement as I helped...
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
December 3, 2008 at 5:47 am
Can you post the schema of the two tables and the query please?
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
December 3, 2008 at 5:28 am
Correct me if I'm wrong, but hasn't this been asked and answered twice before? (exact same insert statement and exact same error)
http://www.sqlservercentral.com/Forums/FindPost610162.aspx
http://www.sqlservercentral.com/Forums/Topic610173-1291-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
December 3, 2008 at 5:09 am
Did you apply the patch to both the server and the machine you're running the client tools from?
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
December 3, 2008 at 4:51 am
Jerry Hung (12/2/2008)
I try to not Remote Desktop if I can, but R.D. makes sense over VPN or for long-running queries
What my colleagues used to do was RD into a...
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
December 3, 2008 at 4:49 am
jwbrown65 (12/3/2008)
We seem to be operable again.Thanks again everyone.
Great.
If I may suggest...
Evaluate your backup strategy in light of this event.
Set up a job to run checkdb (without...
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
December 3, 2008 at 4:46 am
Here's a query that should work
This will work providing you have no table partitioning. If you do, it may give strange results
select object_name(p.object_id), ds.name as FilegroupName
from sys.partitions...
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
December 3, 2008 at 4:45 am
I'm afraid not. Procedures must be called with the EXEC statement and a view may only contain a single SELECT.
If you need to join the output, you'll have to insert...
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
December 3, 2008 at 1:06 am
Try RAISERROR instead of print.
if @search_type <> 'ausId' and @search_type <> 'email'
begin
RAISERROR ('Search Type...
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
December 3, 2008 at 12:58 am
I'd suggest doing it as one statement. If you do the count first and then the insert, there's a chance that another insert could occur in between and make 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
December 3, 2008 at 12:54 am
Sure. It's one of those not-so-intuitive queries (understatement)
This will work providing you have no table partitioning. If you do, it may give strange results
select object_name(p.object_id), ds.name as FilegroupName
...
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
December 3, 2008 at 12:42 am
skjoldtc (12/2/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
December 3, 2008 at 12:06 am
Viewing 15 posts - 42,631 through 42,645 (of 49,552 total)