Viewing 15 posts - 6,076 through 6,090 (of 19,560 total)
EZ PZ
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 2, 2012 at 9:36 am
nice question
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 29, 2012 at 1:50 pm
you're welcome
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 29, 2012 at 1:49 pm
vrsdesign (6/29/2012)
Does FULLTEXT=0 means it is not enabled ?What has to done ? Can I drop it an recread ?
That was a result with the file size internal to sql...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 29, 2012 at 9:50 am
sqlfriends (6/28/2012)
Yes, I ask one developer who has similar table columns, he said SK is surrogated key, NK is natural key
OK - I would not recommend such a naming convention.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 28, 2012 at 9:42 pm
pumpkin
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 28, 2012 at 2:51 pm
In reply to a PM - check this directory where your fulltext is being stored. Check the size in that directory.
S:\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\zoektekstplepl_restyle
Fulltext will add to the size of...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 28, 2012 at 2:02 pm
Can you verify if each of the steps in the following outline have been followed?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 28, 2012 at 1:10 pm
I prefer to use qwerty12345
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 28, 2012 at 12:29 pm
Guessing at what he intended:
SK = SurrogateKey
NK = NonKey
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 28, 2012 at 12:12 pm
FAT CHANCE
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 28, 2012 at 10:42 am
EL Jerry (6/28/2012)
crookj (6/28/2012)
Cliff Jones (6/27/2012)
Lynn Pettis (6/26/2012)
SmokyColorado Springs!
In case you want to see some pictures of the fire:
WOW!! Terrible thing!! I hope everybody is safe up there.
I was in...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 28, 2012 at 10:37 am
It appears you have fulltext enabled. That will add space to your database. Check the filesystem where the fulltext is stored and see how large it is.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 28, 2012 at 10:03 am
thadeushuck (6/28/2012)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 28, 2012 at 10:01 am
Yes, you can create a new schema and grant the user the permissions there. That would limit what the user can do to just that schema.
Create new schema first....
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 28, 2012 at 9:49 am
Viewing 15 posts - 6,076 through 6,090 (of 19,560 total)