Viewing 15 posts - 61 through 75 (of 102 total)
Interview question I hadn't heard before. Thanks.
There is an exception to every rule, except this one...
December 12, 2011 at 9:00 am
GilaMonster (12/12/2011)
It would be spread across both.There may be a performance benefit (or may not)
Can you be more specific as to why or why not better performance please.
There is an exception to every rule, except this one...
December 12, 2011 at 8:42 am
I was using wrong Performance condition :pinch:. Try Object SQLServer:General Statistics and the Counter: Processes blocked.
There is an exception to every rule, except this one...
September 29, 2011 at 9:21 am
Ninja's_RGR'us (8/11/2011)
SQLHeap (8/11/2011)
GilaMonster (8/11/2011)
CREATE NONCLUSTERED INDEX [N2] ON [dbo].table
(
field_name2 ASC,
...
There is an exception to every rule, except this one...
August 12, 2011 at 7:15 am
GilaMonster (8/11/2011)
CREATE NONCLUSTERED INDEX [N2] ON [dbo].table
(
field_name2 ASC,
...
There is an exception to every rule, except this one...
August 11, 2011 at 5:51 pm
Ninja's_RGR'us (8/11/2011)
Without...
There is an exception to every rule, except this one...
August 11, 2011 at 3:02 pm
The id field I'm getting the max from is not the primary clustered index, it is just another column (ID).
CREATE NONCLUSTERED INDEX [N2] ON [dbo].table
(
field_name2 ASC,
field_name1 ASC
)WITH (PAD_INDEX =...
There is an exception to every rule, except this one...
August 11, 2011 at 2:55 pm
It appears to have been a FK issue...the error msg totally threw me off.
There is an exception to every rule, except this one...
June 15, 2011 at 1:26 pm
I've even tried to move the object that it's saying is there to a different schema and I get:
Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'sample',...
There is an exception to every rule, except this one...
June 15, 2011 at 9:24 am
The query you posted returned 1 row verifying "dbo, sample, U". I've checked views, procedures, everything I can think of.
There is an exception to every rule, except this one...
June 15, 2011 at 9:18 am
Ofer Gal (5/11/2011)
This gives me the log space used.I need the data space used or unused
Oops. Here is a query (sql2k compatible) that I use regularly for that.
SET NOCOUNT...
There is an exception to every rule, except this one...
May 11, 2011 at 9:38 am
Ofer Gal (5/11/2011)
and the hard way gives me error:
Unexpected token 'in' in expression or statement.
At D:\Temp\freeInDB.ps1:11 char:40
+ $cmdStatement+=foreach ($DFileGroups in <<<< $db.FileGroups)
I...
There is an exception to every rule, except this one...
May 11, 2011 at 9:08 am
Where can I get this cmdlet Get-SqlDatabase? Am using PSv2.0, SQL08, WinXP.
"The term 'Get-SqlDatabase' is not recognized as the name of a cmdlet,"
There is an exception to every rule, except this one...
May 11, 2011 at 6:35 am
Ok, here is a PS script that is a bit more friendly for multiple subnets. The only downside here is that you will need to know (or get a...
There is an exception to every rule, except this one...
May 10, 2011 at 7:45 am
Thanks for your responses! I have what I was looking for with your help.
There is an exception to every rule, except this one...
May 10, 2011 at 7:11 am
Viewing 15 posts - 61 through 75 (of 102 total)