Viewing 15 posts - 16,156 through 16,170 (of 59,067 total)
There doesn't necessarily need to be a "root tree" in the forest. The landscape can easily have multiple related but still separate trees in the same table.
--Jeff Moden
Change is inevitable... Change for the better is not.
December 3, 2016 at 11:31 am
TheSQLGuru (12/3/2016)
With efficient code (t-sql, EF, Linq, ...) you can do wonders.
EF, as in Entity Framework, has been involved...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 3, 2016 at 11:27 am
CELKO (12/3/2016)
in my table, the column names are dynamic ..
SQL does not work this way. By definition, the columns of a table are known and constant and it...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 3, 2016 at 11:24 am
HanShi (11/25/2016)
Execute it at regular intervals (daily?) and store the results. Build a reporting query on these stored results to get the...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 3, 2016 at 9:13 am
It needs to be dynamic SQL. Details in the code below. Don't ignore the SQL Injection prevention.
--===== This could be a parameter passed to a stored procedure.
DECLARE @pTableName...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 3, 2016 at 9:06 am
Gail Wanabee (12/2/2016)
Jeff Moden (12/1/2016)
Gail Wanabee (12/1/2016)
On a complete server reboot, can you recommend...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 3, 2016 at 7:44 am
LearnSQL!!! (11/30/2016)
SQL server got shutdown caused by tempdb maxing out, how can I trace what\who was running at the moment ? Any help would be appropriated.
Correct identification of the problem...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 3, 2016 at 7:22 am
Grant Fritchey (12/2/2016)
Talib123 (12/2/2016)
I would try the default trace, if your qucik enough you may get some information of what caused the files to grow and at what time.
The system_health...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 3, 2016 at 7:16 am
tacy.highland (12/2/2016)
The only thing I have against these nice simple answers:
As you can see, the neat thing about nice simple answers is that they're nice and simple to modify to...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 3, 2016 at 7:10 am
Michael L John (12/2/2016)
Am I missing something, and if not, will this work?
SELECT CONVERT(varchar(20), CONVERT(time, DATEADD(SECOND, ,<Your field containing seconds>, CONVERT(datetime, CONVERT(date, getdate())))), 100)
You're not missing a thing. I...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 2, 2016 at 3:26 pm
TheSQLGuru (12/1/2016)
SQL CLR Regex would be the way I would go honestly. IIRC someone actually already built a regular expression system for SQL Server using that.
A lot of folks...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 2, 2016 at 6:59 am
mxy (12/1/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
December 1, 2016 at 9:37 pm
Manic Star (12/1/2016)
You should look at regular expressions processing in another language, they are usually a lot more robust that what...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 1, 2016 at 8:53 pm
Rod at work (12/1/2016)
I hope what you said in this article comes true. Been using Pluralsight to learn new skills. So far, nothing.
It's kind of like winning the lottery... you...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 1, 2016 at 8:22 pm
Just add the necessary ORDER BY with a CASE statement that forces 'Full Time' to be first... like this...
WITH summary AS
(
SELECT p.Studentstatus
...
--Jeff Moden
Change is inevitable... Change for the better is not.
December 1, 2016 at 8:14 pm
Viewing 15 posts - 16,156 through 16,170 (of 59,067 total)