Viewing 15 posts - 43,861 through 43,875 (of 49,552 total)
Other than conversions I haven't found a good reason to convert a datetime to a float or int.
I'm sure you could figure out what I meant.
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 12, 2008 at 9:21 am
There's no such thing in SQL as 'Order of rows' unless you specify an order by. The order that the cursor returns them may change from one run to another.
How...
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 12, 2008 at 9:05 am
Peso (10/12/2008)
In my experience, the table variable flushes to disk when approx two pages has been filled.
Interesting. How are you monitoring that?
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 12, 2008 at 9:03 am
Adi Cohn (10/12/2008)
I didn’t try to move a database from SQL Server 2008 to SQL Server 2005, but I’d be very surprised if it will work.
It won't, regardless...
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 12, 2008 at 5:59 am
What statement were you trying to run? Was that the full error message? Was there any reference to what resource it was trying to lock?
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 12, 2008 at 3:19 am
SQL injection is a front end vulnerability that comes from concatenating together SQL statements and executing them.
The way to completely prevent SQL injection is simple, but may take 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
October 12, 2008 at 3:18 am
Audit tables I probably would put a pk onto. Probably just an int identity, but I would want something there to uniquely identify a row. Especially if auditors want reports...
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 12, 2008 at 3:11 am
And, heh... guess I'm still angry at the fact that the DateTime2, Date, and Time won't convert.
Why? Other than conversions I haven't found a good reason to convert a date...
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 12, 2008 at 2:44 am
Dugi (10/12/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 12, 2008 at 2:41 am
rajganesh.dba (10/11/2008)
3.SQL server maximum memory setting changed to more value(like 5Gb) with /3GB and /PAE.
How much memory on that server? Ususally if you've gopt 4 GB then you would want...
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 12, 2008 at 2:34 am
saby (10/11/2008)
gail then wat shud i do... i thing i cannot run this sp on subcription database
Which proc can't you run and why not?
sp_repldone and the others I gave 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 12, 2008 at 2:29 am
Marios Philippopoulos (4/9/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 11, 2008 at 2:05 pm
PaulB (10/11/2008)
1- You do not "fail the entire load", that's just crazy. You reject the failed row/s and report them back to whoever you have to report them.
Then we have...
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 11, 2008 at 1:14 pm
Someone ran a script with a whole lot of truncate and drop statements in it?
SQL doesn't randomly go and drop tables. Someone would have had to do it.
I've seen...
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 11, 2008 at 1:02 pm
I'm reading your posts just fine, thank you.
I don't see why I would want to fail the entire load if I know there's dups in the source data that, for...
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 11, 2008 at 12:55 pm
Viewing 15 posts - 43,861 through 43,875 (of 49,552 total)