Viewing 15 posts - 7,456 through 7,470 (of 13,469 total)
can you post the execution plan as a .sqlplan file here as an attachment?
maybe we can see something you overlooked? a second pair of eyes never hurts!
also, why is there...
June 6, 2011 at 11:27 am
Syed Jahanzaib Bin hassan (6/6/2011)
check the locks on the database,if resources or locks are using by queries and taking time to login then enable the ROW Versioning in SQL Server
What?...
June 6, 2011 at 10:41 am
sqlfriends (6/6/2011)
So, if shrinking files are not a good option, then what should I do?Just watch it getting bigger every day?
regularly scheduled transaction log backups throughout the day.
a database in...
June 6, 2011 at 9:22 am
sdownen05 (6/6/2011)
USE Table1
GO
USE Table2
GO
My question is this: Is there a way to change from one database...
June 6, 2011 at 8:00 am
SQL2008 introduced CDC...Change Data Capture...which is going to do everything you are asking and more, it's built in and it's documented, working and can be implemented on each table you...
June 6, 2011 at 7:49 am
every object is resolved to a four part name when a statement is compiles
ServerName.DatabaseName.SchemaName.ObjectName
ServerName.DatabaseName.SchemaName.Tablename
sometimes you can skip explicitly nameing the object and leave the word between the periods out, and...
June 5, 2011 at 9:07 pm
cino (6/5/2011)
Is this a common good practice? Or is there other specific good reasons we are using these...
June 5, 2011 at 8:57 pm
i think a quick google and read would be more beneficial to you than a brief forum post; once you've read up on the subject a little bit, if you...
June 5, 2011 at 8:08 pm
well based on your data, see what this does for you:
it's assuming less than 10 on the quantity, but it's close;
the assumption of 12 char descrip doesn't work as...
June 3, 2011 at 3:30 pm
kinda fun guessing for now:
assuming you inserted the data into a table with an indeity, i'm joining on found rows to get the price;
it also looks like the descriptiuon is...
June 3, 2011 at 2:26 pm
ahhh ok; definitely more helpful;
State 38 is:
Reason: Failed to open the database specified in the login properties.
June 3, 2011 at 1:44 pm
if you only need the UPC, it looks like you could search for the # sign, and either a space or the end of the row.
this example SEEMs to work...
June 3, 2011 at 1:37 pm
bhoff (6/3/2011)
yeah, I was just thinking about that. The configurations for each are identical in the "HyperBac Configuration Manager", so I don't see how it could matter
i don't either, and...
June 3, 2011 at 11:37 am
only difference i see, beside the REPLACE command at the end, is the wizard script uses file extensions of .vndf and yours is .vmdf
June 3, 2011 at 11:26 am
Guras (6/3/2011)
In SQl server management studio
running sp_who2 active ...
June 3, 2011 at 11:16 am
Viewing 15 posts - 7,456 through 7,470 (of 13,469 total)