Viewing 15 posts - 1,531 through 1,545 (of 2,008 total)
The requirement:
6.7 gigs of data and expected grows around 80 megs a year
November 16, 2011 at 9:19 am
Lowell (11/16/2011)
SQL retrieves the data in what the query engine deems is the fastest way possible, and caches that...
November 16, 2011 at 9:09 am
Charmer (11/16/2011)
yeah....:-)....just few seconds...
Did it work as Expected?
November 16, 2011 at 8:59 am
I am just curious, if table variable is optional and not passed, how do someone find it?
I can't test it but it should behave like Empty Table because Table Type...
November 16, 2011 at 8:48 am
Having said all that, you may wish to reconsider your use of bitmasks, since it breaks the rules of normalisation by storing more than one value in the same column,...
November 16, 2011 at 8:42 am
Charmer (11/16/2011)
the worst part is i don't have any primary column on my table...so i am not able to get any records...
First, why it is required?
Second, if it helps you...
November 16, 2011 at 8:31 am
ashuthinks (11/16/2011)
@gila yes sir...i knew that if i don't use NOLOCK i will definitely get a deadlock so for successful
execution i need to use NOLOCK
You are a victim of...
November 16, 2011 at 8:17 am
I guess you are trying to generalize the shrink operation for all database log file for some configurable number say 15%.
It's not available as option by DBCC SHRINKFILE. But can...
November 16, 2011 at 8:05 am
It's possible with DBCC SHRINKDATABASE.
DBCC SHRINKDATABASE
( database_name | database_id | 0
[ , target_percent ]
[ , { NOTRUNCATE...
November 16, 2011 at 7:44 am
Donald Bouchard (11/16/2011)
November 16, 2011 at 7:23 am
Charmer (11/16/2011)
Hi Dev...did you check out with the query recommended by sumantaroy..?i see no records as output...
I can't explain my pain. I am posting here in SSC & have no...
November 16, 2011 at 7:20 am
R.Mask | POWER(@Big2, D.Dept)
Why are you using Bitwise OR here? Is it required for your logic? Remove it & verify the results.
November 16, 2011 at 7:15 am
Charmer (11/16/2011)
Random Order...!!!?but how come it gives same records every time when we execute the query..?
it must change the order right?
Fine.. Delete few rows & insert same rows again...
November 16, 2011 at 6:53 am
Surely "no one" would run my command line without first editing the path first. Especially since this version is for 2005 and not 2008
Are you sure? 😛
November 16, 2011 at 6:50 am
Viewing 15 posts - 1,531 through 1,545 (of 2,008 total)